//Update public string Update(PriceManagement objPriceManagement, long CurrentId, long?VariationId) { PriceManagement idlist = _db.PriceManagements.Where(c => (c.ItemId == CurrentId) && (c.VariationId == VariationId)).FirstOrDefault(); if (idlist == null) { objPriceManagement.PriceId = 0; _db.PriceManagements.Add(objPriceManagement); } else if (idlist.ItemId == CurrentId && idlist.VariationId == VariationId) { idlist.VariationId = objPriceManagement.VariationId; idlist.VariationAmount = objPriceManagement.VariationAmount; } _db.SaveChanges(); return("Update successfully"); }
//get user by ID public PriceManagement GetPriceManagementById(int id) { PriceManagement priceManagement = _db.PriceManagements.FirstOrDefault(s => s.PriceId == id); return(priceManagement); }
//Insert public string Create(PriceManagement objPriceManagement) { _db.PriceManagements.Add(objPriceManagement); _db.SaveChanges(); return("save successfully"); }