//[Route("SaveFNMBranch")] public ActionResult saveFFM_Unit(FFM_Unit_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(_unitService.SaveFFM_Unit(Fcur), JsonRequestBehavior.AllowGet)); } }
public FFM_Unit_VM EditFFM_Unit(string CmpyCode, string FFM_UNIT_CODE) { ds = _EzBusinessHelper.ExecuteDataSet("Select FFM_UNIT_CODE,NAME,DISPLAY_STATUSfrom FFM_Unit where FFM_UNIT_CODE='" + FFM_UNIT_CODE + "' and Flag=0");// CMPYCODE='" + CmpyCode + "' and dt = ds.Tables[0]; DataRowCollection drc = dt.Rows; FFM_Unit_VM ObjList = new FFM_Unit_VM(); foreach (DataRow dr in drc) { ObjList.FFM_UNIT_CODE = dr["FFM_UNIT_CODE"].ToString(); ObjList.NAME = dr["NAME"].ToString(); ObjList.DISPLAY_STATUS = dr["DISPLAY_STATUS"].ToString(); } return(ObjList); }
public FFM_Unit_VM SaveFFM_Unit(FFM_Unit_VM FCur) { try { DateTime dte; string dtstr1; dte = Convert.ToDateTime(DateTime.Now.ToString()); dtstr1 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); if (!FCur.EditFlag) { var Drecord = new List <string>(); List <FFM_Unit_NewDetails> ObjList = new List <FFM_Unit_NewDetails>(); ObjList.AddRange(FCur.FFM_unitDetailsnew.Select(m => new FFM_Unit_NewDetails { FFM_UNIT_CODE = m.FFM_UNIT_CODE, NAME = m.NAME, CMPYCODE = m.CMPYCODE, DISPLAY_STATUS = m.DISPLAY_STATUS, //MASTER_STATUS = m.MASTER_STATUS }).ToList()); int n = 0; n = ObjList.Count; while (n > 0) { int Stats1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from FFM_Unit where FFM_UNIT_CODE='" + ObjList[n - 1].FFM_UNIT_CODE + "' and CmpyCode='" + ObjList[n - 1].CMPYCODE + "' and flag=0");// CmpyCode='" + FCur.CMPYCODE + "' and if (Stats1 == 0) { StringBuilder sb = new StringBuilder(); sb.Append("'" + ObjList[n - 1].FFM_UNIT_CODE + "',"); sb.Append("'" + ObjList[n - 1].NAME + "',"); sb.Append("'" + FCur.CMPYCODE + "',"); sb.Append("'" + FCur.UserName + "',"); sb.Append("'" + dtstr1 + "',"); //sb.Append("'" + FCur.UserName + "',"); sb.Append("'" + FCur.UserName + "',"); sb.Append("'" + ObjList[n - 1].DISPLAY_STATUS + "',"); sb.Append("'" + dtstr1 + "')"); int i = _EzBusinessHelper.ExecuteNonQuery("insert into FFM_Unit(FFM_UNIT_CODE,NAME,CMPYCODE,CREATED_BY,CREATED_ON,UPDATED_BY,DISPLAY_STATUS,UPDATED_ON) values(" + sb.ToString() + ""); _EzBusinessHelper.ActivityLog(FCur.CMPYCODE, FCur.UserName, "Add FFM CNTR", ObjList[n - 1].FFM_UNIT_CODE, Environment.MachineName); FCur.SaveFlag = true; FCur.ErrorMessage = string.Empty; } else { Drecord.Add(FCur.FFM_UNIT_CODE.ToString()); // branch.Drecord = Drecord; FCur.SaveFlag = false; FCur.ErrorMessage = "Duplicate Record"; } n = n - 1; } return(FCur); } var StatsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from FFM_Unit where FFM_UNIT_CODE='" + FCur.FFM_UNIT_CODE + "' and cmpycode='" + FCur.CMPYCODE + "' and Flag=0");//CmpyCode='" + FCur.CMPYCODE + "' and if (StatsEdit != 0) { StringBuilder sb = new StringBuilder(); sb.Append("FFM_UNIT_CODE='" + FCur.FFM_UNIT_CODE + "',"); sb.Append("NAME='" + FCur.NAME + "',"); sb.Append("DISPLAY_STATUS='" + FCur.DISPLAY_STATUS + "',"); //sb.Append("Note='" + FCur.Note + "',"); sb.Append("UPDATED_BY='" + FCur.UserName + "',"); sb.Append("UPDATED_ON='" + dtstr1 + "'"); _EzBusinessHelper.ExecuteNonQuery("update FFM_Unit set " + sb + " where FFM_UNIT_CODE='" + FCur.FFM_UNIT_CODE + "' and cmpycode='" + FCur.CMPYCODE + "' and Flag=0");//CmpyCode='" + FCur.CMPYCODE + "' and _EzBusinessHelper.ActivityLog(FCur.CMPYCODE, FCur.UserName, "Update Currency", FCur.FFM_UNIT_CODE, Environment.MachineName); FCur.SaveFlag = true; FCur.ErrorMessage = string.Empty; } else { FCur.SaveFlag = false; FCur.ErrorMessage = "Record not available"; } } catch (Exception ex) { FCur.SaveFlag = false; } return(FCur); }
public FFM_Unit_VM SaveFFM_Unit(FFM_Unit_VM FC) { return(_FFM_UnitRepo.SaveFFM_Unit(FC)); }