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