public void Remove(LookUpTitles lookuptitles) { if (Context.Entry(lookuptitles).State == EntityState.Detached) { context.LookUpTitles.Attach(lookuptitles); } context.LookUpTitles.Remove(lookuptitles); }
public DbEntityEntry <LookUpTitles> Entry(LookUpTitles lookuptitles) { return(Context.Entry(lookuptitles)); }
public void Add(LookUpTitles lookuptitles) { context.LookUpTitles.Add(lookuptitles); }
public void Attach(LookUpTitles lookuptitles) { context.LookUpTitles.Attach(lookuptitles); }
public void UpdateLookUpCodes(IEnumerable <LookupCodesViewModel> models, string culture, string name) { if (models == null) { return; } var codeName = models.First().CodeName; var db = context.LookUpCodes.ToList(); var titiles = context.LookUpTitles.Where(a => a.CodeName == codeName && a.Culture == culture).ToList(); foreach (var model in models) { var record = db.FirstOrDefault(a => a.Id == model.Id); var title = titiles.FirstOrDefault(a => a.CodeId == model.CodeId); if (record == null) { //insert var UserCode = new LookUpCode { CodeId = model.CodeId, Name = model.Name, Description = model.Description, EndDate = model.EndDate, CreatedUser = name, StartDate = model.StartDate, CodeName = model.CodeName, CreatedTime = DateTime.Now }; context.LookUpCodes.Add(UserCode); } //Update else { record.Name = model.Name; record.ModifiedTime = DateTime.Now; record.ModifiedUser = name; record.StartDate = model.StartDate; record.EndDate = model.EndDate; record.Description = model.Description; record.CodeId = model.CodeId; record.CodeName = model.CodeName; context.LookUpCodes.Attach(record); context.Entry(record).State = EntityState.Modified; } // if title changed update && insert if (title != null) { title.CodeName = model.CodeName; title.Name = model.Name; title.Title = model.Title; context.LookUpTitles.Attach(title); context.Entry(title).State = EntityState.Modified; } else { var Lookuptitle = new LookUpTitles { Culture = culture, CodeName = model.CodeName, Name = model.Name, Title = model.Title, CodeId = model.CodeId }; context.LookUpTitles.Add(Lookuptitle); } } }