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); }