//[Route("SaveFNMBranch")] public ActionResult SaveFFM_PACKING(FFM_PACKING_VM fpk) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { fpk.CMPYCODE = list[0].CmpyCode; fpk.UserName = list[0].user_name; return(Json(_fpkgService.SaveFFM_PACKING(fpk), JsonRequestBehavior.AllowGet)); } }
public FFM_PACKING_VM EditFFM_PACKING(string CmpyCode, string FFM_PACKING_CODE) { ds = _EzBusinessHelper.ExecuteDataSet("Select FFM_PACKING_CODE,NAME,FFM_PACKING_UID from FFM_PACKING where FFM_PACKING_CODE='" + FFM_PACKING_CODE + "' and Flag=0");// CMPYCODE='" + CmpyCode + "' and dt = ds.Tables[0]; DataRowCollection drc = dt.Rows; FFM_PACKING_VM ObjList = new FFM_PACKING_VM(); foreach (DataRow dr in drc) { ObjList.FFM_PACKING_CODE = dr["FFM_PACKING_CODE"].ToString(); ObjList.NAME = dr["NAME"].ToString(); // ObjList.FFM_PACKING_UID = dr["FFM_PACKING_UID"].ToString(); } return(ObjList); }
public FFM_PACKING_VM SaveFFM_PACKING(FFM_PACKING_VM fpk) { try { DateTime dte; string dtstr1; dte = Convert.ToDateTime(DateTime.Now.ToString()); dtstr1 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); if (!fpk.EditFlag) { var Drecord = new List <string>(); List <FFM_PACKINGDetailNew> ObjList = new List <FFM_PACKINGDetailNew>(); ObjList.AddRange(fpk.FFM_PACKINGDetailNew.Select(m => new FFM_PACKINGDetailNew { FFM_PACKING_CODE = m.FFM_PACKING_CODE, NAME = m.NAME, }).ToList()); int n = 0; n = ObjList.Count; while (n >= 0) { int Stats1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from FFM_PACKING where FFM_PACKING_CODE='" + fpk.FFM_PACKING_CODE + "'");// CmpyCode='" + FCur.CMPYCODE + "' and if (Stats1 == 0) { StringBuilder sb = new StringBuilder(); sb.Append("'" + fpk.CMPYCODE + "',"); sb.Append("'" + ObjList[n - 1].FFM_PACKING_CODE + "',"); sb.Append("'" + ObjList[n - 1].NAME + "',"); sb.Append("'" + fpk.UserName + "',"); sb.Append("'" + fpk.UserName + "',"); sb.Append("'" + dtstr1 + "',"); sb.Append("'" + dtstr1 + "')"); _EzBusinessHelper.ExecuteNonQuery("insert into FFM_PACKING(CMPYCODE,FFM_PACKING_CODE,NAME,CREATED_BY,UPDATED_BY,CREATED_ON,UPDATED_ON) values(" + sb.ToString() + ""); _EzBusinessHelper.ActivityLog(fpk.CMPYCODE, fpk.UserName, "Add Packing Code", ObjList[n - 1].FFM_PACKING_CODE, Environment.MachineName); fpk.SaveFlag = true; fpk.ErrorMessage = string.Empty; } else { Drecord.Add(fpk.FFM_PACKING_CODE.ToString()); // branch.Drecord = Drecord; fpk.SaveFlag = false; fpk.ErrorMessage = "Duplicate Record"; } n = n - 1; } return(fpk); } var StatsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from FFM_PACKING where FFM_PACKING_CODE='" + fpk.FFM_PACKING_CODE + "'and Flag=0");//CmpyCode='" + FCur.CMPYCODE + "' and if (StatsEdit != 0) { StringBuilder sb = new StringBuilder(); // sb.Append("FFM_PACKING_UID='" + fpk.FFM_PACKING_UID + "',"); sb.Append("NAME='" + fpk.NAME + "',"); sb.Append("UPDATED_BY='" + fpk.UserName + "',"); sb.Append("UPDATED_ON='" + dtstr1 + "'"); _EzBusinessHelper.ExecuteNonQuery("update FFM_PACKING set " + sb + " where FFM_PACKING_CODE='" + fpk.FFM_PACKING_CODE + "' and Flag=0");//CmpyCode='" + FCur.CMPYCODE + "' and _EzBusinessHelper.ActivityLog(fpk.CMPYCODE, fpk.UserName, "Update PACKING_CODE", fpk.FFM_PACKING_CODE, Environment.MachineName); fpk.SaveFlag = true; fpk.ErrorMessage = string.Empty; } else { fpk.SaveFlag = false; fpk.ErrorMessage = "Record not available"; } } catch (Exception ex) { fpk.SaveFlag = false; } return(fpk); }
public FFM_PACKING_VM SaveFFM_PACKING(FFM_PACKING_VM FC) { return(_FFMPACKINGRepo.SaveFFM_PACKING(FC)); }