Search baar

To search users by multiple criteria such as User_Name, Email, GST_Number, and Contact Number in an ASP.NET MVC application, you can follow these steps:

Create the Model

First, ensure you have a User model with the properties User_Name, Email, GST_Number, and Contact Number.

public class User
{
    public int Id { get; set; }
    public string User_Name { get; set; }
    public string Email { get; set; }
    public string GST_Number { get; set; }
    public string ContactNumber { get; set; }
}

Create the ViewModel

Create a ViewModel to handle the search criteria.

public class UserSearchViewModel
{
    public string UserName { get; set; }
    public string Email { get; set; }
    public string GSTNumber { get; set; }
    public string ContactNumber { get; set; }
    public List Users { get; set; }
}

Create the Controller

Create a controller with actions to display the search form and to process the search query.

public class UserController : Controller
{
    private readonly ApplicationDbContext _context;

    public UserController()
    {
        _context = new ApplicationDbContext();
    }

    public ActionResult Index()
    {
        var model = new UserSearchViewModel
        {
            Users = new List()
        };
        return View(model);
    }

    [HttpPost]
    public ActionResult Index(UserSearchViewModel model)
    {
        var users = _context.Users.AsQueryable();

        if (!string.IsNullOrEmpty(model.UserName))
        {
            users = users.Where(u => u.User_Name.Contains(model.UserName));
        }

        if (!string.IsNullOrEmpty(model.Email))
        {
            users = users.Where(u => u.Email.Contains(model.Email));
        }

        if (!string.IsNullOrEmpty(model.GSTNumber))
        {
            users = users.Where(u => u.GST_Number.Contains(model.GSTNumber));
        }

        if (!string.IsNullOrEmpty(model.ContactNumber))
        {
            users = users.Where(u => u.ContactNumber.Contains(model.ContactNumber));
        }

        model.Users = users.ToList();
        return View(model);
    }
}

Create the View

Create a view (e.g., Index.cshtml) to display the search form and the results.

@model YourNamespace.Models.UserSearchViewModel

@{
    ViewBag.Title = "User Search";
}

User Search

@using (Html.BeginForm())
{
    
        @Html.LabelFor(m => m.UserName)
        @Html.TextBoxFor(m => m.UserName, new { @class = "form-control" })
    
    
        @Html.LabelFor(m => m.Email)
        @Html.TextBoxFor(m => m.Email, new { @class = "form-control" })
    
    
        @Html.LabelFor(m => m.GSTNumber)
        @Html.TextBoxFor(m => m.GSTNumber, new { @class = "form-control" })
    
    
        @Html.LabelFor(m => m.ContactNumber)
        @Html.TextBoxFor(m => m.ContactNumber, new { @class = "form-control" })
    
    
}

@if (Model.Users.Any())
{
    Search Results
    
            @foreach (var user in Model.Users)
            {
                
            }
        
        
            
                User Name
                Email
                GST Number
                Contact Number
            
        
        
                    @user.User_Name
                    @user.Email
                    @user.GST_Number
                    @user.ContactNumber
                
    
}
else
{
    No users found.
}

User Name	Email	GST Number	Contact Number
@user.User_Name	@user.Email	@user.GST_Number	@user.ContactNumber

Database Context

Ensure your ApplicationDbContext includes a DbSet for your users.

public class ApplicationDbContext : DbContext
{
    public DbSet Users { get; set; }
}

With these steps, you will have a functional search feature in your ASP.NET MVC application that allows you to search users by User_Name, Email, GST_Number, and Contact Number.