public ItemAssignment GetByItemId(int id, int?companyid)
{
ItemAssignment item = context.ItemAssignments.FirstOrDefault(p => p.ItemId == id && p.CompanyId == companyid);
return(item);
}
public string SaveItem(Item item)
{
string msg = "";
if (item.Id == 0)
{
IQueryable <Item> lstItem = List();
IQueryable <ItemAssignment> lstItemAssign = itemAssignmentRepo.List();
lstItem = lstItem.Where(s => s.Description == item.Description.Trim());
lstItemAssign = lstItemAssign.Where(s => s.ItemId == item.Id && s.CompanyId == Sessions.CompanyId);
if (lstItem.Count() == 0 || lstItemAssign.Count() == 0)
{
context.Items.Add(item);
context.SaveChanges();
int itemid = item.Id;
ItemAssignment itemAssign = new ItemAssignment();
itemAssign.ItemId = itemid;
itemAssign.CompanyId = Sessions.CompanyId.Value;
itemAssign.UnitCost = item.UnitCost;
context.ItemAssignments.Add(itemAssign);
msg = "save";
}
else
{
msg = "not save";
}
}
else
{
Item dbEntry = context.Items.Find(item.Id);
int assignid = context.ItemAssignments.FirstOrDefault(p => p.CompanyId == Sessions.CompanyId && p.ItemId == item.Id).Id;
ItemAssignment dbEntry1 = context.ItemAssignments.Find(assignid);
if (dbEntry != null || dbEntry1 != null)
{
// update Items table
dbEntry1.ItemId = item.Id;
dbEntry1.CompanyId = Sessions.CompanyId.Value;
dbEntry1.UnitCost = item.UnitCost;
dbEntry.Description = item.Description;
dbEntry.Brand = item.Brand;
dbEntry.UnitCost = 0;
dbEntry.TypeId = item.TypeId;
dbEntry.ClassificationId = item.ClassificationId;
dbEntry.Active = item.Active;
//
dbEntry1.UnitCost = item.UnitCost;
msg = "updated";
}
}
context.SaveChanges();
return(msg);
}
