public SysPreDefineValue SetToBussinessObjectPreDefineValue(Sys_PreDefineValue Entity)
{
SysPreDefineValue Model = new SysPreDefineValue();
Model.PreDefineValueID = Entity.PreDefineValueID;
//Model.PreDefineValueForID = Entity.PreDefineValueForID;
//Model.Address = Entity.Address;
//Model.ContactPerson = Entity.ContactPerson;
//Model.ContactNumber = Entity.ContactNumber;
//Model.EmailAddress = Entity.EmailAddress;
//Model.FaxNo = Entity.FaxNo;
//Model.PhoneNo = Entity.PhoneNo;
//Model.SkypeID = Entity.SkypeID;
Model.IsActive = Entity.IsActive == true ? "Active" : "Inactive";
return(Model);
}
public SysPreDefineValue SetToBussinessObject(Sys_PreDefineValue Entity)
{
SysPreDefineValue Model = new SysPreDefineValue();
Model.PreDefineValueID = Entity.PreDefineValueID;
Model.PreDefineValueForID = Entity.PreDefineValueForID;
Model.PreDefineValueTitle = Entity.PreDefineValueTitle;
Model.PreDefineValueContent = Entity.PreDefineValueContent;
if (Entity.PreDefineValueGroup == "1")
{
Model.PreDefineValueGroup = "Identity No";
}
else if (Entity.PreDefineValueGroup == "2")
{
Model.PreDefineValueGroup = "CC";
}
else if (Entity.PreDefineValueGroup == "3")
{
Model.PreDefineValueGroup = "Letter Signature";
}
else
{
Model.PreDefineValueGroup = "";
}
if (Entity.PreDefineValueIncreaseBy == "Y")
{
Model.PreDefineValueIncreaseBy = "Yearly";
}
else if (Entity.PreDefineValueIncreaseBy == "M")
{
Model.PreDefineValueIncreaseBy = "Monthly";
}
else if (Entity.PreDefineValueIncreaseBy == "D")
{
Model.PreDefineValueIncreaseBy = "Daily";
}
else if (Entity.PreDefineValueIncreaseBy == "R")
{
Model.PreDefineValueIncreaseBy = "Respectively";
}
else if (Entity.PreDefineValueIncreaseBy == "Y")
{
Model.PreDefineValueIncreaseBy = "Yearly";
}
else if (Entity.PreDefineValueIncreaseBy == "FD")
{
Model.PreDefineValueIncreaseBy = "Yearly";
}
else
{
Model.PreDefineValueIncreaseBy = "";
}
Model.MaxValue = Entity.MaxValue;
Model.InternalMailAddress = Entity.InternalMailAddress;
Model.InternalMailAutoSend = string.IsNullOrEmpty(Entity.InternalMailAutoSend) ? "" : Entity.InternalMailAutoSend;
Model.ExternalMailAddress = Entity.ExternalMailAddress;
Model.ExternalMailAutoSend = string.IsNullOrEmpty(Entity.ExternalMailAutoSend) ? "" : Entity.ExternalMailAutoSend;
Model.Remarks = Entity.Remarks;
Model.IsActive = Entity.IsActive == true ? "Active" : "Inactive";
return(Model);
}
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);
}
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 Sys_PreDefineValue SetToModelObject(SysPreDefineValue model, int userid)
{
Sys_PreDefineValue Entity = new Sys_PreDefineValue();
Entity.PreDefineValueID = model.PreDefineValueID;
Entity.PreDefineValueForID = model.PreDefineValueForID;
Entity.PreDefineValueTitle = model.PreDefineValueTitle;
Entity.PreDefineValueContent = model.PreDefineValueContent;
switch (model.PreDefineValueGroup)
{
case "Identity No":
Entity.PreDefineValueGroup = "1";
if (model.PreDefineValueIncreaseBy == "Yearly")
{
Entity.PreDefineValueIncreaseBy = "Y";
Entity.MaxValue = model.PreDefineValueContent + DateTime.Now.Year.ToString().Substring(DateTime.Now.Year.ToString().Length - 2) + "00" + "00" + "0000";
}
else if (model.PreDefineValueIncreaseBy == "Monthly")
{
Entity.PreDefineValueIncreaseBy = "M";
Entity.MaxValue = model.PreDefineValueContent + DateTime.Now.Year.ToString().Substring(DateTime.Now.Year.ToString().Length - 2) + DateTime.Now.Month.ToString("d2") + "00" + "0000";
}
else if (model.PreDefineValueIncreaseBy == "Daily")
{
Entity.PreDefineValueIncreaseBy = "D";
Entity.MaxValue = model.PreDefineValueContent + DateTime.Now.Year.ToString().Substring(DateTime.Now.Year.ToString().Length - 2) + DateTime.Now.Month.ToString("d2") + DateTime.Now.Day.ToString("d2") + "0000";
}
else if (model.PreDefineValueIncreaseBy == "Respectively")
{
Entity.PreDefineValueIncreaseBy = "R";
Entity.MaxValue = model.PreDefineValueContent + "R0000";
}
else if (model.PreDefineValueIncreaseBy == "Four Digits")
{
Entity.PreDefineValueIncreaseBy = "FD";
Entity.MaxValue = model.PreDefineValueContent + "0000";
}
else
{
Entity.MaxValue = string.Empty;
Entity.PreDefineValueIncreaseBy = string.Empty;
}
break;
case "CC":
Entity.PreDefineValueGroup = "2";
Entity.MaxValue = string.Empty;
Entity.PreDefineValueIncreaseBy = string.Empty;
break;
case "Letter Signature":
Entity.PreDefineValueGroup = "3";
Entity.MaxValue = string.Empty;
Entity.PreDefineValueIncreaseBy = string.Empty;
break;
default:
Entity.PreDefineValueGroup = string.Empty;
break;
}
Entity.InternalMailAddress = string.IsNullOrEmpty(model.InternalMailAddress) ? string.Empty : model.InternalMailAddress;
Entity.InternalMailAutoSend = string.IsNullOrEmpty(model.InternalMailAutoSend) ? string.Empty : model.InternalMailAutoSend;
Entity.ExternalMailAddress = string.IsNullOrEmpty(model.ExternalMailAddress) ? string.Empty : model.ExternalMailAddress;
Entity.ExternalMailAutoSend = string.IsNullOrEmpty(model.ExternalMailAutoSend) ? string.Empty : model.ExternalMailAutoSend;
Entity.Remarks = string.IsNullOrEmpty(model.Remarks) ? string.Empty : model.Remarks;
Entity.IsActive = model.IsActive == "Active";
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = string.Empty;
return(Entity);
}
