public OTVM SaveAP(OTVM OT)
{
string dtstr1 = null;
DateTime dte;
int n;
List <OTExtraATT> ObjList = new List <OTExtraATT>();
if (OT.OTExtraATTnews != null)
{
ObjList.AddRange(OT.OTExtraATTnews.Select(m => new OTExtraATT
{
Att_Date = m.Att_Date,
ATT = (m.ATT).ToString(),
EmpCode = m.EmpCode
}).ToList());
}
n = ObjList.Count;
while (n > 0)
{
dte = Convert.ToDateTime(ObjList[n - 1].Att_Date);
dtstr1 = dte.ToString("yyyy-MM-dd");
_EzBusinessHelper.ExecuteNonQuery("update PRDTD002 set NHrs=0, ATT='" + ObjList[n - 1].ATT + "' where format(Att_Date,'yyyy-MM-dd') ='" + dtstr1 + "' and Empcode ='" + ObjList[n - 1].EmpCode + "' and cmpycode='" + OT.Cmpycode + "'");
n = n - 1;
}
OT.ErrorMessage = string.Empty;
OT.SaveFlag = true;
return(OT);
}
public OTVM SaveOT(OTVM OT)
{
string dtstr1 = null;
DateTime dte;
int n;
List <OTExtraDetail> ObjList = new List <OTExtraDetail>();
if (OT.OTExtraDetailnews != null)
{
ObjList.AddRange(OT.OTExtraDetailnews.Select(m => new OTExtraDetail
{
Att_Date = m.Att_Date,
ExtraHrs = Convert.ToDecimal(m.ExtraHrs),
FOTHrs = Convert.ToDecimal(m.FOThrs),
HOTHrs = Convert.ToDecimal(m.Hhrs),
NHrs = Convert.ToDecimal(m.Nhrs),
OTHrs = Convert.ToDecimal(m.Ohrs),
EmpCode = m.EmpCode
}).ToList());
}
n = ObjList.Count;
while (n > 0)
{
dte = Convert.ToDateTime(ObjList[n - 1].Att_Date);
dtstr1 = dte.ToString("yyyy-MM-dd");
_EzBusinessHelper.ExecuteNonQuery("update PRDTD002 set OTHrs='" + ObjList[n - 1].OTHrs + "',FOTHrs='" + ObjList[n - 1].FOTHrs + "',HOTHrs='" + ObjList[n - 1].HOTHrs + "',Extrahrs='" + ObjList[n - 1].ExtraHrs + "' where format(Att_Date,'yyyy-MM-dd') ='" + dtstr1 + "' and Empcode ='" + ObjList[n - 1].EmpCode + "' and cmpycode='" + OT.Cmpycode + "'");
n = n - 1;
}
OT.ErrorMessage = string.Empty;
OT.SaveFlag = true;
return(OT);
}
public ActionResult SaveOTPayroll(OTVM OTPayroll)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
OTPayroll.Cmpycode = list[0].CmpyCode;
return(Json(_OTPayrollService.SaveOT(OTPayroll), JsonRequestBehavior.AllowGet));
}
}
public OTVM SaveAP(OTVM OT)
{
return(_OTPayrollRepository.SaveAP(OT));
}
