public ActionResult saveFFM_BL(UTM0001_VM UTM)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
UTM.Cmpycode = list[0].CmpyCode;
UTM.UserName = list[0].user_name;
UTM.Branchcode = list[0].BraCode;
return(Json(_CodeService.SaveCodeSettings(UTM), JsonRequestBehavior.AllowGet));
}
}
public UTM0001_VM EditCodeSettings(string Cmpycode, string Branchcode, string UTI0001_CODE)
{
ds = _EzBusinessHelper.ExecuteDataSet("Select * from UTM0001 where Cmpycode='" + Cmpycode + "' and Branchcode='" + Branchcode + "' and UTI0001_CODE='" + UTI0001_CODE + "'");
dt = ds.Tables[0];
DataRowCollection drc = dt.Rows;
UTM0001_VM ObjList = new UTM0001_VM();
foreach (DataRow dr in drc)
{
ObjList.Auto_increment = dr["Auto_increment"].ToString();
ObjList.Last_No = dr["Last_No"].ToString();
ObjList.Page_Name = dr["Page_Name"].ToString();
ObjList.Cmpycode = dr["Cmpycode"].ToString();
ObjList.Branchcode = dr["Branchcode"].ToString();
ObjList.Tablename = dr["Tablename"].ToString();
ObjList.UTI0001_CODE = dr["UTI0001_CODE"].ToString();
ObjList.PREFIX_CODE = dr["PREFIX_CODE"].ToString();
ObjList.Starting_No = dr["Starting_No"].ToString();
ObjList.Total_length = dr["Total_length"].ToString();
ObjList.Module_Type = dr["Module_Type"].ToString();
}
return(ObjList);
}
public UTM0001_VM SaveCodeSettings(UTM0001_VM UTM)
{
return(_CodeSettingsRepo.SaveCodeSettings(UTM));
}
public UTM0001_VM SaveCodeSettings(UTM0001_VM UTM)
{
if (!UTM.EditFlag)
{
try
{
using (TransactionScope scope1 = new TransactionScope())
{
#region UTI0002
List <UTI0002> ObjList1 = new List <UTI0002>();
if (UTM.UTI0002Detail != null)
{
ObjList1.AddRange(UTM.UTI0002Detail.Select(m => new UTI0002
{
APPROVER_ID = m.APPROVER_ID,
APPROVER_NAME = m.APPROVER_NAME,
REJECTED_ALLOW = m.REJECTED_ALLOW,
sno = m.sno,
UTI0001_CODE = m.UTI0001_CODE,
UNAPPROVE_ALLOW = m.UNAPPROVE_ALLOW,
APPROVE_ALLOW = m.APPROVE_ALLOW
}).ToList());
}
#endregion
//---
//checked Code
int c = 0;
c = _EzBusinessHelper.ExecuteScalar("select count(*) from UTM0001 where Cmpycode='" + UTM.Cmpycode + "' and Branchcode='" + UTM.Branchcode + "' and UTI0001_CODE='" + UTM.UTI0001_CODE + "'");
if (c > 0)
{
UTM.ErrorMessage = "Duplicate Code";
UTM.SaveFlag = false;
return(UTM);
}
int n, i = 0;
#region UTI0002 INSERT LOOP
n = ObjList1.Count;
while (n > 0)
{
int Stats1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from UTI0002 where UTI0001_CODE='" + UTM.UTI0001_CODE + "' and Cmpycode='" + UTM.Cmpycode + "' and Branchcode='" + UTM.Branchcode + "' and Tablename='" + UTM.Tablename + "' and APPROVER_ID='" + ObjList1[n - 1].APPROVER_ID + "' ");// CmpyCode='" + FQV.CMPYCODE + "' and and flag=0
if (Stats1 == 0)
{
StringBuilder sb1 = new StringBuilder();
sb1.Append("'" + UTM.UTI0001_CODE + "',");
sb1.Append("'" + UTM.Cmpycode + "',");
sb1.Append("'" + UTM.Branchcode + "',");
sb1.Append("'" + UTM.Tablename + "',");
sb1.Append("'" + ObjList1[n - 1].sno + "',");
sb1.Append("'" + ObjList1[n - 1].APPROVER_ID + "',");
sb1.Append("'" + ObjList1[n - 1].APPROVER_NAME + "',");
sb1.Append("'" + ObjList1[n - 1].APPROVE_ALLOW + "',");
sb1.Append("'" + ObjList1[n - 1].REJECTED_ALLOW + "',");
sb1.Append("'" + ObjList1[n - 1].UNAPPROVE_ALLOW + "')");
i = _EzBusinessHelper.ExecuteNonQuery("insert into UTI0002(UTI0001_CODE,Cmpycode,Branchcode,Tablename,sno,APPROVER_ID,APPROVER_NAME,APPROVE_ALLOW,REJECTED_ALLOW,UNAPPROVE_ALLOW) values(" + sb1.ToString() + "");
}
n = n - 1;
}
#endregion
#region UTM0001 INSERT Header
StringBuilder sb2 = new StringBuilder();
sb2.Append("'" + UTM.Cmpycode + "',");
sb2.Append("'" + UTM.Branchcode + "',");
sb2.Append("'" + UTM.Tablename + "',");
sb2.Append("'" + UTM.Module_Type + "',");
sb2.Append("'" + UTM.UTI0001_CODE + "',");
sb2.Append("'" + UTM.PREFIX_CODE + "',");
sb2.Append("'" + UTM.Page_Name + "',");
sb2.Append("'" + UTM.Starting_No + "',");
sb2.Append("'" + UTM.Total_length + "',");
sb2.Append("'" + UTM.Last_No + "',");
sb2.Append("'" + UTM.Auto_increment + "')");
i = _EzBusinessHelper.ExecuteNonQuery("insert into UTM0001(Cmpycode,Branchcode,Tablename,Module_Type,UTI0001_CODE,PREFIX_CODE,Page_Name,Starting_No,Total_length,Last_No,Auto_increment) values(" + sb2.ToString() + "");
#endregion
_EzBusinessHelper.ActivityLog(UTM.Cmpycode, UTM.UserName, "Update Code Settings", UTM.Tablename, Environment.MachineName);
UTM.SaveFlag = true;
UTM.ErrorMessage = string.Empty;
scope1.Complete();
//}
return(UTM);
}
}
catch (Exception ex)
{
UTM.ErrorMessage = "Error occur";
UTM.SaveFlag = false;
}
}
else
{
try
{
ds = _EzBusinessHelper.ExecuteDataSet("Select * from UTM0001 where Cmpycode='" + UTM.Cmpycode + "' and Branchcode='" + UTM.Branchcode + "' and UTI0001_CODE='" + UTM.UTI0001_CODE + "'");
using (TransactionScope scope1 = new TransactionScope())
{
UTM0001 UTM1 = new UTM0001();
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
UTM1.UTI0001_CODE = UTM.UTI0001_CODE;
UTM1.Cmpycode = UTM.Cmpycode;
UTM1.Auto_increment = UTM.Auto_increment;
UTM1.Branchcode = UTM.Branchcode;
UTM1.Last_No = UTM.Last_No;
UTM1.Page_Name = UTM.Page_Name;
UTM1.PREFIX_CODE = UTM.PREFIX_CODE;
UTM1.Starting_No = UTM.Starting_No;
UTM1.Tablename = UTM.Tablename;
UTM1.Total_length = UTM.Total_length;
UTM1.Module_Type = UTM.Module_Type;
_EzBusinessHelper.ExecuteNonQuery("delete from UTI0002 where Cmpycode='" + UTM.Cmpycode + "' and Branchcode='" + UTM.Branchcode + "' and UTI0001_CODE='" + UTM.UTI0001_CODE + "'");
// #region ObjectList
#region UTI0002
List <UTI0002> ObjList1 = new List <UTI0002>();
if (UTM.UTI0002Detail != null)
{
ObjList1.AddRange(UTM.UTI0002Detail.Select(m => new UTI0002
{
APPROVER_ID = m.APPROVER_ID,
APPROVER_NAME = m.APPROVER_NAME,
Branchcode = m.Branchcode,
Cmpycode = m.Cmpycode,
REJECTED_ALLOW = m.REJECTED_ALLOW,
sno = m.sno,
Tablename = m.Tablename,
UTI0001_CODE = m.UTI0001_CODE,
UNAPPROVE_ALLOW = m.UNAPPROVE_ALLOW,
APPROVE_ALLOW = m.APPROVE_ALLOW
}).ToList());
}
#endregion
//---
int n, i = 0;
#region UTI0002 INSERT LOOP
n = ObjList1.Count;
while (n > 0)
{
int Stats1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from UTI0002 where UTI0001_CODE='" + UTM.UTI0001_CODE + "' and Cmpycode='" + UTM.Cmpycode + "' and Branchcode='" + UTM.Branchcode + "' and Tablename='" + UTM.Tablename + "' and APPROVER_ID='" + ObjList1[n - 1].APPROVER_ID + "' ");// CmpyCode='" + FQV.CMPYCODE + "' and and flag=0
if (Stats1 == 0)
{
StringBuilder sb3 = new StringBuilder();
sb3.Append("'" + UTM.UTI0001_CODE + "',");
sb3.Append("'" + UTM.Cmpycode + "',");
sb3.Append("'" + UTM.Branchcode + "',");
sb3.Append("'" + UTM.Tablename + "',");
sb3.Append("'" + ObjList1[n - 1].sno + "',");
sb3.Append("'" + ObjList1[n - 1].APPROVER_ID + "',");
sb3.Append("'" + ObjList1[n - 1].APPROVER_NAME + "',");
sb3.Append("'" + ObjList1[n - 1].APPROVE_ALLOW + "',");
sb3.Append("'" + ObjList1[n - 1].REJECTED_ALLOW + "',");
sb3.Append("'" + ObjList1[n - 1].UNAPPROVE_ALLOW + "')");
i = _EzBusinessHelper.ExecuteNonQuery("insert into UTI0002(UTI0001_CODE,Cmpycode,Branchcode,Tablename,sno,APPROVER_ID,APPROVER_NAME,APPROVE_ALLOW,REJECTED_ALLOW,UNAPPROVE_ALLOW) values(" + sb3.ToString() + "");
}
n = n - 1;
}
#endregion
#region UTM0001 Update
StringBuilder sb4 = new StringBuilder();
sb4.Append("Tablename='" + UTM.Tablename + "',");
sb4.Append("Module_Type='" + UTM.Module_Type + "',");
sb4.Append("UTI0001_CODE='" + UTM.UTI0001_CODE + "',");
sb4.Append("PREFIX_CODE='" + UTM.PREFIX_CODE + "',");
sb4.Append("Starting_No='" + UTM.Starting_No + "',");
sb4.Append("Total_length='" + UTM.Total_length + "',");
sb4.Append("Last_No='" + UTM.Last_No + "',");
sb4.Append("Page_Name='" + UTM.Page_Name + "',");
sb4.Append("Auto_increment='" + UTM.Auto_increment + "'");
_EzBusinessHelper.ExecuteNonQuery("update UTM0001 set " + sb4 + " where Cmpycode='" + UTM.Cmpycode + "' and Branchcode='" + UTM.Branchcode + "' and UTI0001_CODE='" + UTM.UTI0001_CODE + "'");
#endregion
_EzBusinessHelper.ActivityLog(UTM.Cmpycode, UTM.UserName, "Update Code Settings", UTM.Tablename, Environment.MachineName);
}
UTM.ErrorMessage = string.Empty;
UTM.SaveFlag = true;
scope1.Complete();
}
}
catch (Exception ex)
{
UTM.ErrorMessage = "Error occur";
UTM.SaveFlag = false;
}
}
return(UTM);
}
