public ActionResult SavePjms(ProjectMasterVM Pjms) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { Pjms.CmpyCode = list[0].CmpyCode; Pjms.UserName = list[0].user_name; return(Json(_PjmsService.SavePjms(Pjms), JsonRequestBehavior.AllowGet)); } }
public ProjectMasterVM SavePjms(ProjectMasterVM Pjms) { try { if (!Pjms.EditFlag) { var Drecord = new List <string>(); List <ProjectNew> ObjList = new List <ProjectNew>(); ObjList.AddRange(Pjms.ProjectNew.Select(m => new ProjectNew { Code = m.Code, Active = m.Active, CmpyCode = m.CmpyCode, Name = m.Name, }).ToList()); int n = 0; n = ObjList.Count; while (n > 0) { int Bbs1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from CCH004 where CmpyCode='" + Pjms.CmpyCode + "' and Code='" + ObjList[n - 1].Code + "'"); if (Bbs1 == 0) { StringBuilder sb = new StringBuilder(); sb.Append("'" + Pjms.CmpyCode + "',"); sb.Append("'" + ObjList[n - 1].Code + "',"); sb.Append("'" + ObjList[n - 1].Name + "',"); sb.Append("'" + ObjList[n - 1].Active + "')"); _EzBusinessHelper.ExecuteNonQuery("insert into CCH004(CmpyCode,Code,Name,Active) values(" + sb.ToString() + ""); Pjms.SaveFlag = true; Pjms.ErrorMessage = string.Empty; } else { Drecord.Add(ObjList[n - 1].Code.ToString()); Pjms.Drecord = Drecord; Pjms.SaveFlag = false; Pjms.ErrorMessage = "Duplicate Record"; } n = n - 1; } //int Lons1 = _EzBusinessHelper.ExecuteScalar("Select count(*) from ML031 where CmpyCode='" + Lons.CmpyCode + "' and Code='" + Lons.Code + "'"); //if (Lons1 == 0) //{ // StringBuilder sb = new StringBuilder(); // sb.Append("'" + Lons.CmpyCode + "',"); // sb.Append("'" + Lons.Code + "',"); // sb.Append("'" + Lons.Name + "',"); // sb.Append("'" + Lons.UniCodeName + "')"); // _EzBusinessHelper.ExecuteNonQuery("insert into ML031(CmpyCode,Code,Name,UniCodeName) values(" + sb.ToString() + ""); // Lons.SaveFlag = true; // Lons.ErrorMessage = string.Empty; //} //else //{ // Lons.SaveFlag = false; // Lons.ErrorMessage = "Duplicate Record"; //} return(Pjms); } var PjmsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from CCH004 where CmpyCode='" + Pjms.CmpyCode + "' and Code='" + Pjms.Code + "'and Flag=0"); if (PjmsEdit != 0) { _EzBusinessHelper.ExecuteNonQuery("update CCH004 set Name='" + Pjms.Name + "',Active='" + Pjms.Active + "' where CmpyCode='" + Pjms.CmpyCode + "' and Code='" + Pjms.Code + "'"); Pjms.SaveFlag = true; Pjms.ErrorMessage = string.Empty; } else { Pjms.SaveFlag = false; Pjms.ErrorMessage = "Record not available"; } } catch (Exception ex) { Pjms.SaveFlag = false; // unit.ErrorMessage = exceptionMessage; } return(Pjms); }
public ProjectMasterVM SavePjms(ProjectMasterVM Pjms) { return(_PjmsRepo.SavePjms(Pjms)); }