public ActionResult SaveFFM_JOB(FFM_JOB_VM Fcur)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
Fcur.CMPYCODE = list[0].CmpyCode;
Fcur.UserName = list[0].user_name;
return(Json(_FFMJOBService.SaveFFM_JOB(Fcur), JsonRequestBehavior.AllowGet));
}
}
public FFM_JOB_VM SaveFFM_JOB(FFM_JOB_VM FJ)
{
return(_FFMJOBRepo.SaveFM_JOBHEAD(FJ));
}
public FFM_JOB_VM SaveFM_JOBHEAD(FFM_JOB_VM FJ)
{
DateTime dte;
string dtstr1;
dte = Convert.ToDateTime(DateTime.Now.ToString());
dtstr1 = dte.ToString("yyyy-MM-dd hh:mm:ss tt");
try
{
if (!FJ.EditFlag)
{
var Drecord = new List <string>();
List <FFM_JOBNew> ObjList = new List <FFM_JOBNew>();
ObjList.AddRange(FJ.FFM_JOBNew.Select(m => new FFM_JOBNew
{
CREATED_BY = m.CREATED_BY,
CREATED_ON = m.CREATED_ON,
UPDATED_BY = m.UPDATED_BY,
UPDATED_ON = m.UPDATED_ON,
CMPYCODE = m.CMPYCODE,
FFM_JOB_CODE = m.FFM_JOB_CODE,
NAME = m.NAME,
DISPLAY_STATUS = m.DISPLAY_STATUS,
}).ToList());
int n = 0;
n = ObjList.Count;
while (n > 0)
{
int Stats1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from FFM_JOB where CmpyCode='" + FJ.CMPYCODE + "' and FFM_JOB_CODE='" + ObjList[n - 1].FFM_JOB_CODE + "'");
if (Stats1 == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + FJ.CMPYCODE + "',");
sb.Append("'" + ObjList[n - 1].FFM_JOB_CODE + "',");
sb.Append("'" + ObjList[n - 1].NAME + "',");
sb.Append("'" + FJ.UserName + "',");
sb.Append("'" + dtstr1 + "',");
sb.Append("'" + FJ.UserName + "',");
sb.Append("'" + dtstr1 + "',");
sb.Append("'" + ObjList[n - 1].DISPLAY_STATUS + "')");
_EzBusinessHelper.ExecuteNonQuery("insert into FFM_JOB(CMPYCODE,FFM_JOB_CODE,NAME,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,DISPLAY_STATUS) values(" + sb.ToString() + "");
_EzBusinessHelper.ActivityLog(FJ.CMPYCODE, FJ.UserName, "Add FN Category", ObjList[n - 1].FFM_JOB_CODE, Environment.MachineName);
FJ.SaveFlag = true;
FJ.ErrorMessage = string.Empty;
}
else
{
Drecord.Add(ObjList[n - 1].FFM_JOB_CODE.ToString());
FJ.Drecord = Drecord;
FJ.SaveFlag = false;
FJ.ErrorMessage = "Duplicate Record";
}
n = n - 1;
}
return(FJ);
}
var StatsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from FFM_JOB where CmpyCode='" + FJ.CMPYCODE + "' and FFM_JOB_CODE='" + FJ.FFM_JOB_CODE + "'and Flag=0");
if (StatsEdit != 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("CMPYCODE='" + FJ.CMPYCODE + "',");
sb.Append("FFM_JOB_CODE='" + FJ.FFM_JOB_CODE + "',");
sb.Append("NAME='" + FJ.NAME + "',");
sb.Append("CREATED_BY='" + FJ.UserName + "',");
sb.Append("CREATED_ON='" + dtstr1 + "',");
sb.Append("UPDATED_BY='" + FJ.UserName + "',");
sb.Append("UPDATED_ON='" + dtstr1 + "',");
sb.Append("DISPLAY_STATUS='" + FJ.DISPLAY_STATUS + "'");
_EzBusinessHelper.ExecuteNonQuery("update FFM_JOB set " + sb + " where FFM_JOB_CODE='" + FJ.FFM_JOB_CODE + "' and Flag=0");
_EzBusinessHelper.ActivityLog(FJ.CMPYCODE, FJ.UserName, "Update FMHead", FJ.FFM_JOB_CODE, Environment.MachineName);
FJ.SaveFlag = true;
FJ.ErrorMessage = string.Empty;
}
else
{
FJ.SaveFlag = false;
FJ.ErrorMessage = "Record not available";
}
}
catch (Exception ex)
{
FJ.SaveFlag = false;
}
return(FJ);
}
