Showing posts with label WEBGRID. Show all posts
Showing posts with label WEBGRID. Show all posts

Tuesday, July 4, 2017

Asp.net MVC : Export data to PDF file

MVC , WEBGRID
Asp.net MVC : Export data to PDF file
In this article I am going to explain how to export data to PDF file in asp.net MVC. 
In previous article I have explained how to export data to Excel file in asp.net MVC, how to checkuploaded image is Grayscale or not in asp.net and how to check height and width(dimensions) and size of image before uploading in asp.net.
 Description:I have created table Employees and insert some dummy data into it. I want to export the data to PDF files. I am using itextsharp DLL to generate PDF file.
 Implementation: 
Read more »
By at No comments:
Tags: ,

Saturday, April 30, 2016

How to filter records in MVC Webgrid using textbox

MVC , WEBGRID
How to filter records in MVC Webgrid using textbox
In this article I am going to explain how to filter record in MVC Webgrid based on textbox.
 
How to filter records in MVC Webgrid using textbox
Click to enlarge

Implementation:

Model:
Model class (Employee.cs)

   public partial class Employee
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public Nullable<int> Phone { get; set; }
        public Nullable<int> Salary { get; set; }
        public string Department { get; set; }
        public string ImagePath { get; set; }
        public string EmailId { get; set; }
    }

Controller:
I have added a controller to project and write code to search the record.

using MVC_Project.Models;
DemoEntities1 db = new DemoEntities1();
        //
        // GET: /Employee/

        public ActionResult Index()
        {
            return View(db.Employees.ToList());
        }
        //Filter :/Employee/
        [HttpPost]
        public ActionResult Index(string SearchName)
        {
            var Employee = from em in db.Employees
                           where em.Name.Contains(SearchName)
                           select em;              
            return View(Employee);
        }

View:
Add the view for index. Below given is code of view (Index.cshtml)

@model IEnumerable<MVC_Project.Models.Employee>

<style type="text/css">
  
    .webgrid {
        font-size: 1.2em;
        width: 80%;

        display: table;    
        border-collapse: collapse;
    }     
    .header {
        background-color: #3F95C5;
        color: #fff;
        padding-bottom: 4px;
        padding-top: 5px;
        text-align: center;
    }
    .header a {
        text-decoration: none;
        color: #fff;
    }
    td {
            text-align: center;
        }
    table img
    {
        width:150px;
    }
    .row-style {
        background-color :#E6E6E6;
    }
    .row-style:hover {
        background-color: #C0C0C0;
    }
   
     .alternating-row {
        background-color: #DEEDF5;
    }
        .alternating-row:hover {
            background-color: #6EA0C3;
        }
</style>
@using(Html.BeginForm())
{
  @Html.Label("Enter Name :-")  @Html.TextBox("SearchName", "", new { placeholder = "Name" })  <input type="submit" value="Filter" />
}

@{var grid = new WebGrid(Model, canSort: true, canPage: true);
  }
@grid.GetHtml(
        tableStyle: "webgrid",
        headerStyle: "header",
        footerStyle: "footer",
        rowStyle: "row-style",
        alternatingRowStyle: "alternating-row",
    mode: WebGridPagerModes.All,
    columns: grid.Columns
    (
        grid.Column("Name","Name"),
        grid.Column("Phone","Phone"),
        grid.Column("Salary","Salary"),
         grid.Column("Department","Department"),
         //if else condition to check email id
             grid.Column("Email",format: (item) =>
             {
                 if (item.emailid == null)
                     return Html.Raw("Email not available");
                 else
                     return (item.EmailId);
             }),       
       //if else condition to display image
       grid.Column("Image",format: (item) =>
                 {
                     if (item.ImagePath == null)
                         return Html.Raw (string.Format("<text><img src=\"{0}\" alt=\"Image\"/></text>", Url.Content("~/images/image.jpg")));
                     else
                         return Html.Raw(string.Format("<text><img src=\"{0}\" alt=\"Image\" /></text>", Url.Content(item.ImagePath)));
                 }),      
               
grid.Column("Edit",format:@<text>@Html.ActionLink("Edit", "Update", new { id = item.ID })</text>),
grid.Column("Delete",format:@<text>@Html.ActionLink("Delete", "Delete", new { id = item.ID })</text>)
   )
     )


Read more »
By at No comments:
Tags: ,

Friday, April 29, 2016

How to apply (set) custom style on MVC webgrid

MVC , WEBGRID
How to apply (set) custom style on MVC webgrid
By at No comments:
Tags: ,

Friday, April 22, 2016

ASP.NET MVC: Dynamically display images in webgrid

MVC , WEBGRID
ASP.NET MVC: Dynamically display images in webgrid
By at No comments:
Tags: ,