public List <ProductDataView> GetAllProductsByName(string name)
{
List <ProductDataView> products = new List <ProductDataView>();
List <Product> pList = new List <Product>();
using (mydbEntities db = new mydbEntities())
{
ProductsDataView PSR = new ProductsDataView();
var p1 = db.Products.Where(o => o.product_name.Contains(name));
if (p1.Any())
{
pList = p1.ToList();
foreach (Product p in pList)
{
ProductDataView PR = new ProductDataView();
PR.product_id = p.product_id;
PR.product_name = p.product_name;
PR.product_price = p.product_price;
PR.product_address = p.product_address;
products.Add(PR);
}
}
return(products);
}
}
public ActionResult GetAllProductsByName(string name)
{
UserManager UM = new UserManager();
ProductsDataView PDV = new ProductsDataView();
PDV.Products = UM.GetAllProductsByName(name);
return(PartialView(PDV));
}
public ProductsDataView GetProductDataView()
{
ProductsDataView PDC = new ProductsDataView();
List <ProductDataView> products = GetAllProducts();
PDC.Products = products;
return(PDC);
}
public ActionResult GetAllProductsByFiler(string productname, string productaddress, string productprice)
{
UserManager UM = new UserManager();
ProductsDataView PDV = new ProductsDataView();
if (productprice == "")
{
productprice = "1000000";
}
PDV.Products = UM.GetAllProductsByFiler(productname, productaddress, Convert.ToInt32(productprice));
return(PartialView(PDV));
}
public ActionResult Products(string status = "")
{
UserManager UM = new UserManager();
ProductsDataView UDV = UM.GetProductDataView();
string message = string.Empty;
if (status.Equals("update"))
{
message = "Update Successful";
}
else if (status.Equals("delete"))
{
message = "Delete Successful";
}
ViewBag.Message = message;
return(PartialView(UDV));
}
