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 UpdateProductData(int id, string pName, int pPrice, string address)
{
ProductDataView PDV = new ProductDataView();
PDV.product_id = id;
PDV.product_name = pName;
PDV.product_price = pPrice;
PDV.product_address = address;
UserManager UM = new UserManager();
UM.UpdateProduct(PDV);
return(Json(new { success = true }));
}
public ActionResult AddProduct(string pName, int pPrice, string address, int pSid)
{
ProductDataView UDV = new ProductDataView();
UDV.product_id = 0;
UDV.product_name = pName;
UDV.product_price = pPrice;
UDV.product_address = address;
UDV.SupllierID = pSid;
UserManager UM = new UserManager();
UM.AddProduct(UDV);
return(Json(new { success = true }));
}
public ProductDataView GetProductData(int productID)
{
ProductDataView PD = new ProductDataView();
using (mydbEntities db = new mydbEntities())
{
var product = db.Products.Find(productID);
if (product != null)
{
PD.product_id = product.product_id;
PD.product_name = product.product_name;
PD.product_price = product.product_price;
PD.product_address = product.product_address;
}
}
return(PD);
}
public void AddProduct(ProductDataView product)
{
using (mydbEntities db = new mydbEntities())
{
var intIdt = db.Products.Max(u => (int)u.product_id);
Product PR = new Product();
PR.product_id = intIdt + 1;
PR.product_name = product.product_name;
PR.product_price = product.product_price;
PR.product_address = product.product_address;
PR.SupllierID = product.SupllierID;
db.Products.Add(PR);
db.SaveChanges();
}
}
public void UpdateProduct(ProductDataView product)
{
using (mydbEntities db = new mydbEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Product PU = db.Products.Find(product.product_id);
PU.product_name = product.product_name;
PU.product_price = product.product_price;
PU.product_address = product.product_address;
db.SaveChanges();
dbContextTransaction.Commit();
}
catch
{
dbContextTransaction.Rollback();
}
}
}
}
public List <ProductDataView> GetAllProducts()
{
List <ProductDataView> products = new List <ProductDataView>();
using (mydbEntities db = new mydbEntities())
{
ProductDataView PR;
var pros = db.Products.GroupBy(price => price.product_price).ToList();
if (pros != null)
{
foreach (IGrouping <int, Product> p1 in pros)
{
foreach (Product p in p1)
{
PR = new ProductDataView();
PR = GetProductData(p.product_id);
products.Add(PR);
}
}
}
}
return(products);
}
