//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");
}
