public SysPreDefineValueFor SetToBussinessObject(MenuItem Entity) { SysPreDefineValueFor Model = new SysPreDefineValueFor(); Model.ConcernPageID = Entity.ScreenCode; Model.ConcernPage = _context.Screens.Where(m => m.IsActive && m.ScreenCode == Entity.ScreenCode).FirstOrDefault().Title; return(Model); }
public ActionResult PreDefineValue(SysPreDefineValueFor model) { if (model != null && model.PreDefineValueForID != 0) { _vmMsg = _dalSysPreDefineValue.Update(model, Convert.ToInt32(Session["UserID"])); } else { _vmMsg = _dalSysPreDefineValue.Save(model, Convert.ToInt32(Session["UserID"])); } return(Json(new { PreDefineValueForID = _dalSysPreDefineValue.GetPreDefineValueForId(), msg = _vmMsg })); }
public SysPreDefineValueFor SetToBussinessObjectPreDefineValueFor(Sys_PreDefineValueFor Entity) { SysPreDefineValueFor Model = new SysPreDefineValueFor(); Model.PreDefineValueForID = Entity.PreDefineValueForID; Model.PreDefineValueFor = Entity.PreDefineValueFor; Model.ConcernPageID = Entity.ConcernPageID; Model.ConcernPage = _context.Screens.Where(m => m.ScreenCode == Entity.ConcernPageID).FirstOrDefault().Title; Model.Remarks = Entity.Remarks; return(Model); }
public SysPreDefineValueFor SetToBussinessObjectPreDefineValueForForSearch(Sys_PreDefineValueFor Entity) { SysPreDefineValueFor Model = new SysPreDefineValueFor(); Model.PreDefineValueForID = Entity.PreDefineValueForID; Model.PreDefineValueFor = Entity.PreDefineValueFor; Model.ConcernPageID = Entity.ConcernPageID; //Model.PreDefineValueForCategory = Entity.PreDefineValueForCategory; //Model.PreDefineValueForType = Entity.PreDefineValueForType; Model.IsActive = Entity.IsActive == true ? "Active" : "Inactive"; return(Model); }
public Sys_PreDefineValueFor SetToModelObject(SysPreDefineValueFor model, int userid) { Sys_PreDefineValueFor Entity = new Sys_PreDefineValueFor(); Entity.PreDefineValueForID = model.PreDefineValueForID; Entity.PreDefineValueFor = model.PreDefineValueFor; Entity.ConcernPageID = model.ConcernPageID; Entity.Remarks = model.Remarks; Entity.IsActive = model.IsActive == "Active"; Entity.SetOn = DateTime.Now; Entity.SetBy = userid; Entity.IPAddress = string.Empty; return(Entity); }
public ValidationMsg Save(SysPreDefineValueFor model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { #region PreDefineValueFor Sys_PreDefineValueFor tblSysPreDefineValueFor = SetToModelObject(model, userid); _context.Sys_PreDefineValueFor.Add(tblSysPreDefineValueFor); _context.SaveChanges(); PreDefineValueForID = tblSysPreDefineValueFor.PreDefineValueForID; #endregion #region Save PreDefineValue if (model.PreDefineValueList != null) { foreach (SysPreDefineValue objSysPreDefineValue in model.PreDefineValueList) { objSysPreDefineValue.PreDefineValueForID = PreDefineValueForID; objSysPreDefineValue.IsActive = string.IsNullOrEmpty(objSysPreDefineValue.IsActive) ? "Active" : objSysPreDefineValue.IsActive; @group = objSysPreDefineValue.PreDefineValueGroup == "Identity No" ? "1" : "0"; if (group == "1") { var exitData = _context.Sys_PreDefineValue.Where(m => m.PreDefineValueForID == PreDefineValueForID && m.PreDefineValueGroup == "1" && m.IsActive == true).ToList(); if (exitData.Count > 0) { exitidentuty = 1; } else { Sys_PreDefineValue tblPreDefineValue = SetToModelObject(objSysPreDefineValue, userid); var sameData = _context.Sys_PreDefineValue.Where(m => m.PreDefineValueForID == PreDefineValueForID && m.PreDefineValueGroup == "1" && m.PreDefineValueContent == objSysPreDefineValue.PreDefineValueContent && m.PreDefineValueIncreaseBy == tblPreDefineValue.PreDefineValueIncreaseBy).ToList(); if (sameData.Count > 0) { sameidentuty = 1; } else { _context.Sys_PreDefineValue.Add(tblPreDefineValue); _context.SaveChanges(); } } } else { Sys_PreDefineValue tblPreDefineValue = SetToModelObject(objSysPreDefineValue, userid); _context.Sys_PreDefineValue.Add(tblPreDefineValue); _context.SaveChanges(); } } } #endregion if (exitidentuty == 0) { if (sameidentuty == 0) { tx.Complete(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Same Combination Found."; } } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "An Active Data Found Same Group."; } //if ((exitidentuty == 0) && (sameidentuty == 0)) //{ // //_context.SaveChanges(); // tx.Complete(); // _vmMsg.Type = Enums.MessageType.Success; // _vmMsg.Msg = "Saved Successfully."; //} //else //{ // _vmMsg.Type = Enums.MessageType.Error; // _vmMsg.Msg = "Please Enter Only One Identity Group."; //} } } } catch (Exception ex) { if (ex.InnerException != null) { if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY")) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Concern Page Code Already Exit.."; } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } } return(_vmMsg); }
public ValidationMsg Update(SysPreDefineValueFor model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { Sys_PreDefineValueFor CurrentEntity = SetToModelObject(model, userid); var OriginalEntity = _context.Sys_PreDefineValueFor.First(m => m.PreDefineValueForID == model.PreDefineValueForID); OriginalEntity.PreDefineValueFor = CurrentEntity.PreDefineValueFor; OriginalEntity.ConcernPageID = CurrentEntity.ConcernPageID; OriginalEntity.Remarks = CurrentEntity.Remarks; OriginalEntity.IsActive = CurrentEntity.IsActive; OriginalEntity.ModifiedBy = userid; OriginalEntity.ModifiedOn = DateTime.Now; #region Save PreDefineValueFor if (model.PreDefineValueList != null) { foreach (SysPreDefineValue objSysPreDefineValue in model.PreDefineValueList) { if (objSysPreDefineValue.PreDefineValueID == 0) { objSysPreDefineValue.PreDefineValueForID = model.PreDefineValueForID; objSysPreDefineValue.IsActive = string.IsNullOrEmpty(objSysPreDefineValue.IsActive) ? "Active" : objSysPreDefineValue.IsActive; @group = objSysPreDefineValue.PreDefineValueGroup == "Identity No" ? "1" : "0"; if (group == "1") { var exitData = _context.Sys_PreDefineValue.Where( m => m.PreDefineValueForID == model.PreDefineValueForID && m.PreDefineValueGroup == "1" && m.IsActive == true).ToList(); if (exitData.Count > 0) { exitidentuty = 1; } else { Sys_PreDefineValue tblPreDefineValue = SetToModelObject(objSysPreDefineValue, userid); var sameData = _context.Sys_PreDefineValue.Where(m => m.PreDefineValueForID == model.PreDefineValueForID && m.PreDefineValueGroup == "1" && m.PreDefineValueContent == objSysPreDefineValue.PreDefineValueContent && m.PreDefineValueIncreaseBy == tblPreDefineValue.PreDefineValueIncreaseBy).ToList(); if (sameData.Count > 0) { sameidentuty = 1; } else { _context.Sys_PreDefineValue.Add(tblPreDefineValue); _context.SaveChanges(); } } } else { Sys_PreDefineValue tblPreDefineValue = SetToModelObject(objSysPreDefineValue, userid); _context.Sys_PreDefineValue.Add(tblPreDefineValue); _context.SaveChanges(); } } else { if ((objSysPreDefineValue.PreDefineValueGroup == "Identity No") && (objSysPreDefineValue.IsActive == "Active")) { group = "1"; } else if ((objSysPreDefineValue.PreDefineValueGroup == "Identity No") && (objSysPreDefineValue.IsActive == null)) { group = "1"; } else { group = "0"; } if (group == "1") { var exitData = _context.Sys_PreDefineValue.Where( m => m.PreDefineValueForID == model.PreDefineValueForID && m.PreDefineValueGroup == "1" && m.IsActive == true).ToList(); if (exitData.Count > 0) { exitidentuty = 1; } else { objSysPreDefineValue.IsActive = string.IsNullOrEmpty(objSysPreDefineValue.IsActive) ? "Active" : objSysPreDefineValue.IsActive; Sys_PreDefineValue CurEntity = SetToModelObject(objSysPreDefineValue, userid); var OrgEntity = _context.Sys_PreDefineValue.First( m => m.PreDefineValueID == objSysPreDefineValue.PreDefineValueID); //OrgEntity.PreDefineValueTitle = CurEntity.PreDefineValueTitle; //OrgEntity.PreDefineValueContent = CurEntity.PreDefineValueContent; //OrgEntity.PreDefineValueGroup = CurEntity.PreDefineValueGroup; //OrgEntity.PreDefineValueIncreaseBy = CurEntity.PreDefineValueIncreaseBy; //OrgEntity.MaxValue = CurEntity.MaxValue; //OrgEntity.InternalMailAddress = CurEntity.InternalMailAddress; //OrgEntity.InternalMailAutoSend = CurEntity.InternalMailAutoSend; //OrgEntity.ExternalMailAddress = CurEntity.ExternalMailAddress; //OrgEntity.ExternalMailAutoSend = CurEntity.ExternalMailAutoSend; //OrgEntity.Remarks = CurEntity.Remarks; OrgEntity.IsActive = CurEntity.IsActive; OrgEntity.ModifiedBy = userid; OrgEntity.ModifiedOn = DateTime.Now; } } else { objSysPreDefineValue.IsActive = string.IsNullOrEmpty(objSysPreDefineValue.IsActive) ? "Active" : objSysPreDefineValue.IsActive; Sys_PreDefineValue CurEntity = SetToModelObject(objSysPreDefineValue, userid); var OrgEntity = _context.Sys_PreDefineValue.First( m => m.PreDefineValueID == objSysPreDefineValue.PreDefineValueID); //OrgEntity.PreDefineValueTitle = CurEntity.PreDefineValueTitle; //OrgEntity.PreDefineValueContent = CurEntity.PreDefineValueContent; //OrgEntity.PreDefineValueGroup = CurEntity.PreDefineValueGroup; //OrgEntity.PreDefineValueIncreaseBy = CurEntity.PreDefineValueIncreaseBy; //OrgEntity.MaxValue = CurEntity.MaxValue; //OrgEntity.InternalMailAddress = CurEntity.InternalMailAddress; //OrgEntity.InternalMailAutoSend = CurEntity.InternalMailAutoSend; //OrgEntity.ExternalMailAddress = CurEntity.ExternalMailAddress; //OrgEntity.ExternalMailAutoSend = CurEntity.ExternalMailAutoSend; //OrgEntity.Remarks = CurEntity.Remarks; OrgEntity.IsActive = CurEntity.IsActive; OrgEntity.ModifiedBy = userid; OrgEntity.ModifiedOn = DateTime.Now; } } } } #endregion if (exitidentuty == 0) { if (sameidentuty == 0) { _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Same Combination Found."; } } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "An Active Data Found Same Group."; } } } } catch (Exception ex) { if (ex.InnerException != null) { if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY")) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Concern Page Code Already Exit."; } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Update."; } } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Update."; } } return(_vmMsg); }