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