public ActionResult SaveFFM_JOB(FFM_JOB_VM Fcur) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { Fcur.CMPYCODE = list[0].CmpyCode; Fcur.UserName = list[0].user_name; return(Json(_FFMJOBService.SaveFFM_JOB(Fcur), JsonRequestBehavior.AllowGet)); } }
public FFM_JOB_VM SaveFFM_JOB(FFM_JOB_VM FJ) { return(_FFMJOBRepo.SaveFM_JOBHEAD(FJ)); }
public FFM_JOB_VM SaveFM_JOBHEAD(FFM_JOB_VM FJ) { DateTime dte; string dtstr1; dte = Convert.ToDateTime(DateTime.Now.ToString()); dtstr1 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); try { if (!FJ.EditFlag) { var Drecord = new List <string>(); List <FFM_JOBNew> ObjList = new List <FFM_JOBNew>(); ObjList.AddRange(FJ.FFM_JOBNew.Select(m => new FFM_JOBNew { CREATED_BY = m.CREATED_BY, CREATED_ON = m.CREATED_ON, UPDATED_BY = m.UPDATED_BY, UPDATED_ON = m.UPDATED_ON, CMPYCODE = m.CMPYCODE, FFM_JOB_CODE = m.FFM_JOB_CODE, NAME = m.NAME, DISPLAY_STATUS = m.DISPLAY_STATUS, }).ToList()); int n = 0; n = ObjList.Count; while (n > 0) { int Stats1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from FFM_JOB where CmpyCode='" + FJ.CMPYCODE + "' and FFM_JOB_CODE='" + ObjList[n - 1].FFM_JOB_CODE + "'"); if (Stats1 == 0) { StringBuilder sb = new StringBuilder(); sb.Append("'" + FJ.CMPYCODE + "',"); sb.Append("'" + ObjList[n - 1].FFM_JOB_CODE + "',"); sb.Append("'" + ObjList[n - 1].NAME + "',"); sb.Append("'" + FJ.UserName + "',"); sb.Append("'" + dtstr1 + "',"); sb.Append("'" + FJ.UserName + "',"); sb.Append("'" + dtstr1 + "',"); sb.Append("'" + ObjList[n - 1].DISPLAY_STATUS + "')"); _EzBusinessHelper.ExecuteNonQuery("insert into FFM_JOB(CMPYCODE,FFM_JOB_CODE,NAME,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,DISPLAY_STATUS) values(" + sb.ToString() + ""); _EzBusinessHelper.ActivityLog(FJ.CMPYCODE, FJ.UserName, "Add FN Category", ObjList[n - 1].FFM_JOB_CODE, Environment.MachineName); FJ.SaveFlag = true; FJ.ErrorMessage = string.Empty; } else { Drecord.Add(ObjList[n - 1].FFM_JOB_CODE.ToString()); FJ.Drecord = Drecord; FJ.SaveFlag = false; FJ.ErrorMessage = "Duplicate Record"; } n = n - 1; } return(FJ); } var StatsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from FFM_JOB where CmpyCode='" + FJ.CMPYCODE + "' and FFM_JOB_CODE='" + FJ.FFM_JOB_CODE + "'and Flag=0"); if (StatsEdit != 0) { StringBuilder sb = new StringBuilder(); sb.Append("CMPYCODE='" + FJ.CMPYCODE + "',"); sb.Append("FFM_JOB_CODE='" + FJ.FFM_JOB_CODE + "',"); sb.Append("NAME='" + FJ.NAME + "',"); sb.Append("CREATED_BY='" + FJ.UserName + "',"); sb.Append("CREATED_ON='" + dtstr1 + "',"); sb.Append("UPDATED_BY='" + FJ.UserName + "',"); sb.Append("UPDATED_ON='" + dtstr1 + "',"); sb.Append("DISPLAY_STATUS='" + FJ.DISPLAY_STATUS + "'"); _EzBusinessHelper.ExecuteNonQuery("update FFM_JOB set " + sb + " where FFM_JOB_CODE='" + FJ.FFM_JOB_CODE + "' and Flag=0"); _EzBusinessHelper.ActivityLog(FJ.CMPYCODE, FJ.UserName, "Update FMHead", FJ.FFM_JOB_CODE, Environment.MachineName); FJ.SaveFlag = true; FJ.ErrorMessage = string.Empty; } else { FJ.SaveFlag = false; FJ.ErrorMessage = "Record not available"; } } catch (Exception ex) { FJ.SaveFlag = false; } return(FJ); }