public IActionResult Profession(ProfessionVM vm)
{
if (!ModelState.IsValid)
{
return(View(vm));
}
else
{
HttpContext.Session.SetString("Profession", vm.ProfessionChoice);
return(RedirectToAction("SelectSaveSlot"));
}
}
public ActionResult SavePros(ProfessionVM Pros)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
Pros.CmpyCode = list[0].CmpyCode;
Pros.UserName = list[0].user_name;
return(Json(_ProService.SavePros(Pros), JsonRequestBehavior.AllowGet));
}
}
public ProfessionVM SavePros(ProfessionVM Pros)
{
try
{
if (!Pros.EditFlag)
{
var Drecord = new List <string>();
List <ProfessionDetailnew> ObjList = new List <ProfessionDetailnew>();
ObjList.AddRange(Pros.ProfessionDetailnew.Select(m => new ProfessionDetailnew
{
CmpyCode = m.CmpyCode,
ProfCode = m.ProfCode,
ProfName = m.ProfName,
// UniCodeName = m.UniCodeName
}).ToList());
int n = 0;
n = ObjList.Count;
while (n > 0)
{
int Pros1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from MPROF021 where CmpyCode='" + Pros.CmpyCode + "' and ProfCode='" + ObjList[n - 1].ProfCode + "'");
if (Pros1 == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + Pros.CmpyCode + "',");
sb.Append("'" + ObjList[n - 1].ProfCode + "',");
sb.Append("'" + ObjList[n - 1].ProfName + "')");
// sb.Append("'" + ObjList[n - 1].UniCodeName + "')");
_EzBusinessHelper.ExecuteNonQuery("insert into MPROF021(CmpyCode,ProfCode,ProfName) values(" + sb.ToString() + "");
_EzBusinessHelper.ActivityLog(Pros.CmpyCode, Pros.UserName, "Added PayRoll Config Master", ObjList[n - 1].ProfCode, Environment.MachineName);
Pros.SaveFlag = true;
Pros.ErrorMessage = string.Empty;
}
else
{
Drecord.Add(ObjList[n - 1].ProfCode.ToString());
Pros.Drecord = Drecord;
Pros.SaveFlag = false;
Pros.ErrorMessage = "Duplicate Record";
}
n = n - 1;
}
return(Pros);
}
var StatsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from MPROF021 where CmpyCode='" + Pros.CmpyCode + "' and ProfCode='" + Pros.ProfCode + "' and Flag=0");
if (StatsEdit != 0)
{
_EzBusinessHelper.ExecuteNonQuery("update MPROF021 set CmpyCode='" + Pros.CmpyCode + "',ProfCode='" + Pros.ProfCode + "',Name='" + Pros.ProfName + "' where CmpyCode='" + Pros.CmpyCode + "' and ProfCode='" + Pros.ProfCode + "'");
_EzBusinessHelper.ActivityLog(Pros.CmpyCode, Pros.UserName, "Update PayRoll Config Master", Pros.ProfCode, Environment.MachineName);
Pros.SaveFlag = true;
Pros.ErrorMessage = string.Empty;
}
else
{
Pros.SaveFlag = false;
Pros.ErrorMessage = "Record not available";
}
}
catch (Exception ex)
{
Pros.SaveFlag = false;
// unit.ErrorMessage = exceptionMessage;
}
return(Pros);
}
public IActionResult Profession()
{
ProfessionVM vm = new ProfessionVM();
return(View(vm));
}
public ProfessionVM SavePros(ProfessionVM Pros)
{
return(_ProRepo.SavePros(Pros));
}
