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