public EmpShiftVM SaveEmpShift(EmpShiftVM Sft)
{
if (!Sft.EditFlag)
{
Sft.PRSFT003_code = _CodeRep.GetCode(Sft.CmpyCode, "EMPShiftMaster");
}
return(_EmpShiftRepo.SaveEmpShift(Sft));
}
public ActionResult SaveEmpShift(EmpShiftVM Sft)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
Sft.CmpyCode = list[0].CmpyCode;
Sft.UserName = list[0].user_name;
return(Json(_EmpShiftService.SaveEmpShift(Sft), JsonRequestBehavior.AllowGet));
}
}
public EmpShiftVM SaveEmpShift(EmpShiftVM Sft)
{
if (!Sft.EditFlag)
{
int Exi = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from PRSFT003 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT003_code='" + Sft.PRSFT003_code + "' and Flag=0");
int pno = _EzBusinessHelper.ExecuteScalar("Select Nos from PARTTBL001 where CmpyCode='" + Sft.CmpyCode + "' and Code='PRSFT' ");
if (Exi == 0)
{
_EzBusinessHelper.ExecuteNonQuery("insert into PRSFT003(PRSFT003_code,PRSFT002_code,PRSFT001_code,SNO,EmpCode,Remarks,CmpyCode) values('" + Sft.PRSFT003_code + "','" + Sft.PRSFT002_code + "','" + Sft.PRSFT001_code + "','" + Sft.SNO + "','" + Sft.EmpCode + "','" + Sft.Remarks + "','" + Sft.CmpyCode + "')");
_EzBusinessHelper.ExecuteNonQuery(" UPDATE PARTTBL001 SET Nos = " + (pno + 1) + " where CmpyCode='" + Sft.CmpyCode + "' and Code='PRSFT'");
Sft.SaveFlag = true;
Sft.ErrorMessage = string.Empty;
}
else
{
Sft.SaveFlag = false;
Sft.ErrorMessage = "Duplicate Record";
}
}
else
{
int n = 0;
//_EzBusinessHelper.ExecuteScalar("Select count(*) from PRSFT003 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "'");
n = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRSFT003 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT003_code='" + Sft.PRSFT003_code + "' ");
if (n != 0)
{
_EzBusinessHelper.ExecuteNonQuery("delete from PRSFT003 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT003_code='" + Sft.PRSFT003_code + "'");
_EzBusinessHelper.ExecuteNonQuery("insert into PRSFT003(PRSFT003_code,PRSFT002_code,PRSFT001_code,SNO,EmpCode,Remarks,CmpyCode) values('" + Sft.PRSFT003_code + "','" + Sft.PRSFT002_code + "','" + Sft.PRSFT001_code + "','" + Sft.SNO + "','" + Sft.EmpCode + "','" + Sft.Remarks + "','" + Sft.CmpyCode + "')");
Sft.SaveFlag = true;
Sft.ErrorMessage = string.Empty;
}
else
{
Sft.SaveFlag = true;
Sft.ErrorMessage = "Error occur";
}
}
return(Sft);
}
public EmpShiftVM GetEmpShiftEdit(string CmpyCode, string PRSFT003_code)
{
ds = _EzBusinessHelper.ExecuteDataSet("Select * from PRSFT003 where CmpyCode='" + CmpyCode + "' and PRSFT003_code='" + PRSFT003_code + "' and Flag=0");
dt = ds.Tables[0];
EmpShiftVM es = new EmpShiftVM();
foreach (DataRow dr in dt.Rows)
{
es.CmpyCode = dr["CmpyCode"].ToString();
es.EmpCode = dr["EmpCode"].ToString();
es.PRSFT002_code = dr["PRSFT002_code"].ToString();
es.Remarks = dr["Remarks"].ToString();
es.SNO = Convert.ToInt32(dr["SNO"].ToString());
es.PRSFT003_code = dr["Remarks"].ToString();
es.PRSFT001_code = dr["PRSFT001_code"].ToString();
}
return(es);
}
