public ProjectAllotmentVM SaveProjectAllotment(ProjectAllotmentVM PrjAlt)
{
if (!PrjAlt.EditFlag)
{
PrjAlt.PRPRJE001_code = _CodeRep.GetCode(PrjAlt.CmpyCode, "EMPProjectAllotment");
}
return(_ProjectAllotRepo.SaveProjectAllotment(PrjAlt));
}
public ProjectAllotmentVM SaveProjectAllotment(ProjectAllotmentVM PrjAlt)
{
DateTime dte;
string dtstr1, dtstr2;
dte = Convert.ToDateTime(PrjAlt.Entery_date.ToString());
dtstr1 = dte.ToString("yyyy-MM-dd hh:mm:ss tt");
dte = Convert.ToDateTime(PrjAlt.Effect_From.ToString());
dtstr2 = dte.ToString("yyyy-MM-dd hh:mm:ss tt");
if (!PrjAlt.EditFlag)
{
int Exi = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from PRPRJE001 where CmpyCode='" + PrjAlt.CmpyCode + "' and PRSFT003_code='" + PrjAlt.PRPRJE001_code + "'");
int pno = _EzBusinessHelper.ExecuteScalar("Select Nos from PARTTBL001 where CmpyCode='" + PrjAlt.CmpyCode + "' and Code='PRPRJE' ");
if (Exi == 0)
{
_EzBusinessHelper.ExecuteNonQuery("insert into PRPRJE001(PRPRJE001_code,CCH004_code,Entery_date,Effect_From,EmpCode,Remarks,CmpyCode) values('" + PrjAlt.PRPRJE001_code + "','" + PrjAlt.CCH004_code + "','" + dtstr1 + "','" + dtstr2 + "','" + PrjAlt.EmpCode + "','" + PrjAlt.Remarks + "','" + PrjAlt.CmpyCode + "')");
_EzBusinessHelper.ExecuteNonQuery("update PRDTD002 set Project_code='" + PrjAlt.CCH004_code + "' where EmpCode='" + PrjAlt.EmpCode + "' and Att_Date >='" + dtstr2 + "' and CmpyCode='" + PrjAlt.CmpyCode + "' ");
_EzBusinessHelper.ActivityLog(PrjAlt.CmpyCode, PrjAlt.UserName, "Insert Project Allotment", PrjAlt.PRPRJE001_code, Environment.MachineName);
_EzBusinessHelper.ExecuteNonQuery("UPDATE PARTTBL001 SET Nos = " + (pno + 1) + " where CmpyCode='" + PrjAlt.CmpyCode + "' and Code='PRPRJE'");
PrjAlt.SaveFlag = true;
PrjAlt.ErrorMessage = string.Empty;
}
else
{
PrjAlt.SaveFlag = false;
PrjAlt.ErrorMessage = "Duplicate Record";
}
}
else
{
int n = 0;
n = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRPRJE001 where CmpyCode='" + PrjAlt.CmpyCode + "' and PRPRJE001_code='" + PrjAlt.PRPRJE001_code + "' ");
if (n != 0)
{
_EzBusinessHelper.ExecuteNonQuery("UPDATE PRPRJE001 set CCH004_code='" + PrjAlt.CCH004_code + "',Entery_date='" + dtstr1 + "',Effect_From='" + dtstr2 + "',EmpCode='" + PrjAlt.EmpCode + "',Remarks='" + PrjAlt.Remarks + "' where PRPRJE001_code='" + PrjAlt.PRPRJE001_code + "' and CmpyCode='" + PrjAlt.CmpyCode + "'");
_EzBusinessHelper.ExecuteNonQuery("update PRDTD002 set Project_code='" + PrjAlt.CCH004_code + "' where EmpCode='" + PrjAlt.EmpCode + "' and Att_Date >='" + dtstr2 + "' and CmpyCode='" + PrjAlt.CmpyCode + "' ");
_EzBusinessHelper.ActivityLog(PrjAlt.CmpyCode, PrjAlt.UserName, "Update Project Allotment", PrjAlt.PRPRJE001_code, Environment.MachineName);
PrjAlt.SaveFlag = true;
PrjAlt.ErrorMessage = string.Empty;
}
else
{
PrjAlt.SaveFlag = true;
PrjAlt.ErrorMessage = "Error occur";
}
}
return(PrjAlt);
}
public ActionResult SaveEmpShift(ProjectAllotmentVM PrjAll)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
PrjAll.CmpyCode = list[0].CmpyCode;
PrjAll.UserName = list[0].user_name;
return(Json(_ProjectAllotService.SaveProjectAllotment(PrjAll), JsonRequestBehavior.AllowGet));
}
}
public ProjectAllotmentVM GetProjectAllotmentEdit(string CmpyCode, string PRPRJE001_code)
{
ds = _EzBusinessHelper.ExecuteDataSet("Select * from PRPRJE001 where CmpyCode='" + CmpyCode + "' and PRPRJE001_code='" + PRPRJE001_code + "' and Flag=0");
dt = ds.Tables[0];
ProjectAllotmentVM es = new ProjectAllotmentVM();
foreach (DataRow dr in dt.Rows)
{
es.CmpyCode = dr["CmpyCode"].ToString();
es.PRPRJE001_code = dr["PRPRJE001_code"].ToString();
es.EmpCode = dr["EmpCode"].ToString();
es.Remarks = dr["Remarks"].ToString();
es.CCH004_code = dr["CCH004_code"].ToString();
es.Effect_From = Convert.ToDateTime(dr["Effect_From"].ToString());
es.Entery_date = Convert.ToDateTime(dr["Entery_date"].ToString());
}
return(es);
}
