public ShiftMasterVM SaveShift(ShiftMasterVM Sft)
{
if (!Sft.EditFlag)
{
Sft.PRSFT001_code = _codeRep.GetCode(Sft.CmpyCode, "ShiftMaster");
}
return(_ShiftPayrollRepo.SaveShift(Sft));
}
public ActionResult SaveShift(ShiftMasterVM 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(_ShiftService.SaveShift(Sft), JsonRequestBehavior.AllowGet));
}
}
public ShiftMasterVM GetShiftEdit(string CmpyCode, string PRSFT001_code)
{
ds = _EzBusinessHelper.ExecuteDataSet("Select * from PRSFT001 where CmpyCode='" + CmpyCode + "' and PRSFT001_code='" + PRSFT001_code + "'and Flag=0");
dt = ds.Tables[0];
ShiftMasterVM pr = new ShiftMasterVM();
foreach (DataRow dr in dt.Rows)
{
pr.CmpyCode = dr["CmpyCode"].ToString();
pr.PRSFT001_code = dr["PRSFT001_code"].ToString();
pr.country = dr["country"].ToString();
pr.StTime = dr["StTime"].ToString();
pr.EdTime = dr["EdTime"].ToString();
pr.division = dr["division"].ToString();
pr.ShiftName = dr["ShiftName"].ToString();
}
return(pr);
}
public ShiftMasterVM SaveShift(ShiftMasterVM Sft)
{
int n;
int k = 0;
string Dst1, Dst2 = null;
DateTime dt1, dt2;
string Approved;
if (!Sft.EditFlag)
{
ShiftMaster pt = new ShiftMaster();
int pno = _EzBusinessHelper.ExecuteScalar("Select Nos from PARTTBL001 where CmpyCode='" + Sft.CmpyCode + "' and Code='PRSFT' ");
//pt.PRBM001_code = string.Concat("PRBM", "-", (pno + 1).ToString().PadLeft(4, '0')).ToString();
List <ShiftAllocationH> ObjList = new List <ShiftAllocationH>();
ObjList.AddRange(Sft.Shift.Select(m => new ShiftAllocationH
{
CmpyCode = m.CmpyCode,
PRSFT002_code = m.PRSFT002_code,
PRSFT001_code = m.PRSFT001_code,
Enttry_Date = m.Enttry_Date,
Effect_Date = m.Effect_Date,
division = m.division,
ApprovalYN = m.ApprovalYN,
}).ToList());
k = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRSFT001 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "' ");
n = ObjList.Count;
if (n != 0 && k == 0)
{
using (TransactionScope scope = new TransactionScope())
{
_EzBusinessHelper.ExecuteNonQuery("insert into PRSFT001(PRSFT001_code,CmpyCode,country,division,ShiftName,StTime,EdTime) values('" + Sft.PRSFT001_code + "','" + Sft.CmpyCode + "','" + Sft.country + "','" + Sft.division + "','" + Sft.ShiftName + "','" + Sft.StTime + "','" + Sft.EdTime + "')");
while (n > 0)
{
dt1 = Convert.ToDateTime(ObjList[n - 1].Enttry_Date.ToString());
Dst1 = dt1.ToString("yyyy-MM-dd hh:mm:ss tt");
dt2 = Convert.ToDateTime(ObjList[n - 1].Effect_Date.ToString());
Dst2 = dt2.ToString("yyyy-MM-dd hh:mm:ss tt");
//if (ObjList[n - 1].ApprovalYN ="YES")
// Approved = "Y";
//else
// Approved = "N";
_EzBusinessHelper.ExecuteNonQuery("insert into PRSFT002(PRSFT001_code,PRSFT002_code,CmpyCode,division,Enttry_Date,Effect_Date,ApprovalYN) values('" + Sft.PRSFT001_code + "','" + ObjList[n - 1].PRSFT002_code + "','" + Sft.CmpyCode + "', '" + ObjList[n - 1].division + "', '" + Dst1 + "', '" + Dst2 + "', '" + ObjList[n - 1].ApprovalYN + "')");
n = n - 1;
}
_EzBusinessHelper.ActivityLog(Sft.CmpyCode, Sft.UserName, "Add Shift Master", Sft.PRSFT001_code, Environment.MachineName);
_EzBusinessHelper.ExecuteNonQuery("UPDATE PARTTBL001 SET Nos =" + (pno + 1) + " where CmpyCode='" + Sft.CmpyCode + "' and Code='PRSFT'");
Sft.SaveFlag = true;
Sft.ErrorMessage = string.Empty;
scope.Complete();
}
}
else
{
Sft.SaveFlag = true;
Sft.ErrorMessage = "Duplicate Record";
}
}
else
{
k = 0;//_EzBusinessHelper.ExecuteScalar("Select count(*) from PRSFT003 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "'");
n = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRSFT001 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "' ");
if (n != 0 && k == 0)
{
string DT1, DT2;
using (TransactionScope scope1 = new TransactionScope())
{
_EzBusinessHelper.ExecuteNonQuery("delete from PRSFT001 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "'");
_EzBusinessHelper.ExecuteNonQuery("delete from PRSFT002 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "'");
ShiftMaster pt = new ShiftMaster();
List <ShiftAllocationH> ObjList = new List <ShiftAllocationH>();
ObjList.AddRange(Sft.Shift.Select(m => new ShiftAllocationH
{
PRSFT001_code = m.PRSFT001_code,
PRSFT002_code = m.PRSFT002_code,
CmpyCode = m.CmpyCode,
ApprovalYN = m.ApprovalYN,
division = m.division,
Effect_Date = m.Effect_Date,
Enttry_Date = m.Enttry_Date
}).ToList());
_EzBusinessHelper.ExecuteNonQuery("insert into PRSFT001(PRSFT001_code,CmpyCode,country,division,ShiftName,StTime,EdTime) values('" + Sft.PRSFT001_code + "','" + Sft.CmpyCode + "','" + Sft.country + "','" + Sft.division + "','" + Sft.ShiftName + "','" + Sft.StTime + "','" + Sft.EdTime + "')");
n = ObjList.Count;
while (n > 0)
{
dt1 = Convert.ToDateTime(ObjList[n - 1].Enttry_Date.ToString());
Dst1 = dt1.ToString("yyyy-MM-dd hh:mm:ss tt");
dt2 = Convert.ToDateTime(ObjList[n - 1].Effect_Date.ToString());
Dst2 = dt2.ToString("yyyy-MM-dd hh:mm:ss tt");
_EzBusinessHelper.ExecuteNonQuery("insert into PRSFT002(PRSFT001_code,PRSFT002_code,CmpyCode,division,Enttry_Date,Effect_Date,ApprovalYN) values('" + Sft.PRSFT001_code + "','" + ObjList[n - 1].PRSFT002_code + "','" + Sft.CmpyCode + "', '" + ObjList[n - 1].division + "', '" + Dst1 + "', '" + Dst2 + "', '" + ObjList[n - 1].ApprovalYN + "')");
n = n - 1;
}
_EzBusinessHelper.ActivityLog(Sft.CmpyCode, Sft.UserName, "Update Shift Master", Sft.PRSFT001_code, Environment.MachineName);
Sft.SaveFlag = true;
Sft.ErrorMessage = string.Empty;
scope1.Complete();
}
}
else
{
Sft.SaveFlag = true;
Sft.ErrorMessage = "Error occur";
}
}
return(Sft);
}
