public void Remove(LookUpUserCode UserCode) { if (Context.Entry(UserCode).State == EntityState.Detached) { context.LookUpUserCodes.Attach(UserCode); } context.LookUpUserCodes.Remove(UserCode); }
public ActionResult AddOption(SelectOptionsViewModel model) { var message = "OK,"; if (ModelState.IsValid) { if (model.IsLookUp == 1) ///Lookup Code { var lookupCodes = _hrUnitOfWork.Repository <LookUpCode>().Where(c => c.CodeName == model.SourceName).ToList(); if (lookupCodes.Count == 0) { return(Json(2)); } var isExists = lookupCodes.Where(c => c.Name == model._Name).FirstOrDefault() != null; if (isExists) { ModelState.AddModelError("_Name", MsgUtils.Instance.Trls("AlreadyExists")); return(Json(Models.Utils.ParseFormErrors(ModelState))); } else { LookUpCode newLookupCode = new LookUpCode(); var codeId = (short)(lookupCodes.Count == 0 ? 1 : lookupCodes.Select(c => c.CodeId).ToList().Max() + 1); model._Id = codeId; newLookupCode.CodeName = model.SourceName.ToString(); newLookupCode.CodeId = codeId; newLookupCode.Name = model._Name; newLookupCode.StartDate = new DateTime(2010, 1, 1); newLookupCode.CreatedTime = DateTime.Now; newLookupCode.CreatedUser = UserName; _hrUnitOfWork.LookUpRepository.Add(newLookupCode); } } else if (model.IsLookUp == 2)///Lookup User Code { LookUpUserCode newUserCode = new LookUpUserCode(); var userCodes = _hrUnitOfWork.Repository <LookUpUserCode>().Where(c => c.CodeName == model.SourceName).ToList(); var isExists = userCodes.Where(c => c.Name == model._Name).FirstOrDefault() != null; if (isExists) { ModelState.AddModelError("_Name", MsgUtils.Instance.Trls("AlreadyExists")); return(Json(Models.Utils.ParseFormErrors(ModelState))); } else { var codeId = (short)(userCodes.Count == 0 ? 1 : userCodes.Select(c => c.CodeId).ToList().Max() + 1); model._Id = codeId; newUserCode.CodeName = model.SourceName.ToString(); newUserCode.CodeId = codeId; newUserCode.Name = model._Name; if (model.ColumnsNames == null) { ModelState.AddModelError("SysCodeId", MsgUtils.Instance.Trls("Required")); return(Json(Models.Utils.ParseFormErrors(ModelState))); } int index = model.ColumnsNames.FindIndex(c => c == "SysCodeId"); byte sysCodeId; byte.TryParse(model.ColumnsValue[index], out sysCodeId); newUserCode.SysCodeId = sysCodeId; newUserCode.StartDate = new DateTime(2010, 1, 1); newUserCode.CreatedTime = DateTime.Now; newUserCode.CreatedUser = UserName; _hrUnitOfWork.LookUpRepository.Add(newUserCode); } } else if (model.SourceName != null)///Object { // get table name from the object var tableName = _hrUnitOfWork.Repository <PageDiv>().Where(p => p.CompanyId == CompanyId && p.ObjectName == model.SourceName && p.Version == 0).Select(p => p.TableName).FirstOrDefault(); if (tableName.Length == 0) { return(Json("Table is not exist in page tables")); } model.ColumnsNames.Add("CreatedUser"); model.ColumnsNames.Add("CreatedTime"); model.ColumnsValue.Add(UserName); model.ColumnsValue.Add(DateTime.Now + ""); var res = _hrUnitOfWork.PagesRepository.AddToTable(model, tableName, CompanyId); if (res == 0) //Saved Fail { return(Json(MsgUtils.Instance.Trls("CanotSaveData"))); } else { model._Id = res; } } var Errors = SaveChanges(Language); if (Errors.Count > 0 || message.IndexOf("OK") < 0) { message = Errors.First().errors.First().message; } else { if (model.IsLookUp == 1) { model.seqId = _hrUnitOfWork.Repository <LookUpCode>().Where(c => c.CodeName == model.SourceName && c.CodeId == model._Id && c.Name == model._Name).FirstOrDefault().Id; } message += (new JavaScriptSerializer()).Serialize(model); } return(Json(message)); } return(Json(Models.Utils.ParseFormErrors(ModelState))); }
public DbEntityEntry <LookUpUserCode> Entry(LookUpUserCode lookupusercode) { return(Context.Entry(lookupusercode)); }
public void Attach(LookUpUserCode lookupusercode) { context.LookUpUserCodes.Attach(lookupusercode); }
public void Add(LookUpUserCode lookupusercode) { context.LookUpUserCodes.Add(lookupusercode); }
public void UpdateLookUpUserCode(IEnumerable <LookupUserCodeViewModel> models, string culture, string name) { if (models == null) { return; } var codeName = models.First().CodeName; var db = context.LookUpUserCodes.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 LookUpUserCode { SysCodeId = model.SysCodeId, CodeId = model.CodeId, Name = model.Name, Description = model.Description, EndDate = model.EndDate, CreatedUser = name, StartDate = model.StartDate, CodeName = model.CodeName, CreatedTime = DateTime.Now }; context.LookUpUserCodes.Add(UserCode); } //Update else { record.Id = model.Id; record.Name = model.Name; record.ModifiedTime = DateTime.Now; record.ModifiedUser = name; record.SysCodeId = model.SysCodeId; record.StartDate = model.StartDate; record.EndDate = model.EndDate; record.Description = model.Description; record.CodeId = model.CodeId; record.CodeName = model.CodeName; context.LookUpUserCodes.Attach(record); context.Entry(record).State = EntityState.Modified; } // if title changed update && insert if (title != null) { title.CodeId = model.CodeId; 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); } } }