public int UpdateItem(ItemsModel model, int id)
{
try
{
var list = (from Items in dbContext.ScItems
where Items.Description == model.Description && Items.ItemCategoryId == model.ItemCategoryId && Items.ItemId != id
select Items).Count();
if (list == 0)
{
ScItems item = new ScItems();
item.ItemId = model.ItemId;
item.ItemCategoryId = model.ItemCategoryId;
item.Description = model.Description;
item.Price = model.Price;
item.DisplayOrder = model.DisplayOrder;
item.IsInOffer = model.IsInOffer;
item.OfferValidFrom = model.OfferValidFrom;
item.OfferValidTo = model.OfferValidTo;
item.OfferPrice = model.OfferPrice;
dbContext.Entry(item).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
dbContext.SaveChanges();
return(1);
}
else
{
return(-1);
}
}
catch (Exception ex)
{
return(0);
}
}
public int DeleteItem(int id)
{
try
{
ScItems item = dbContext.ScItems.Find(id);
if (item != null)
{
dbContext.ScItems.Remove(item);
dbContext.SaveChanges();
return(1);
}
else
{
return(0);
}
}
catch (Exception ex)
{
return(0);
}
}
public int AddItem(ItemsModel model)
{
try
{
var list = (from Items in dbContext.ScItems
where Items.Description == model.Description && Items.ItemCategoryId == model.ItemCategoryId
select Items).Count();
if (list == 0)
{
ScItems newItem = new ScItems();
newItem.ItemCategoryId = model.ItemCategoryId;
newItem.Description = model.Description;
newItem.Price = model.Price;
newItem.DisplayOrder = model.DisplayOrder;
newItem.IsInOffer = model.IsInOffer;
newItem.OfferValidFrom = model.OfferValidFrom;
newItem.OfferValidTo = model.OfferValidTo;
newItem.OfferPrice = model.OfferPrice;
dbContext.Add(newItem);
dbContext.SaveChanges();
model.ItemId = newItem.ItemId;
return(newItem.ItemId);
}
else
{
return(-1);
}
}
catch (Exception ex)
{
return(0);
}
}
