public FNM_AC_COA_VM EditFNM_AC_COA(string CmpyCode, string Code)
{
ds = _EzBusinessHelper.ExecuteDataSet("Select CMPYCODE,branchcode,FNM_AC_COA_CODE,NAME,Head_code,group_code,SUBGROUP_code,COA_TYPE,SUBLEDGER_TYPE,SUBLEDGER_CAT,MASTER_STATUS,NOTE,NATURE,Name_Arabic,PL_BS from FNM_AC_COA where CMPYCODE='" + CmpyCode + "' and FNM_AC_COA_CODE='" + Code + "' and Flag=0");//
dt = ds.Tables[0];
DataRowCollection drc = dt.Rows;
FNM_AC_COA_VM ObjList = new FNM_AC_COA_VM();
foreach (DataRow dr in drc)
{
ObjList.COMPANY_UID = dr["CMPYCODE"].ToString();
ObjList.CODE = dr["FNM_AC_COA_CODE"].ToString();
ObjList.NAME = dr["NAME"].ToString();
ObjList.Head_code = dr["Head_code"].ToString();
ObjList.group_code = dr["group_code"].ToString();
ObjList.SUBGROUP_code = dr["SUBGROUP_code"].ToString();
ObjList.COA_TYPE = dr["COA_TYPE"].ToString();
ObjList.SUBLEDGER_TYPE = dr["SUBLEDGER_TYPE"].ToString();
ObjList.SUBLEDGER_CAT = dr["SUBLEDGER_CAT"].ToString();
ObjList.MASTER_STATUS = dr["MASTER_STATUS"].ToString();
ObjList.NOTE = dr["NOTE"].ToString();
ObjList.NATURE = dr["NATURE"].ToString();
ObjList.Name_Arabic = dr["Name_Arabic"].ToString();
ObjList.FNMBRANCH_CODE = dr["branchcode"].ToString();
ObjList.PL_BS = dr["PL_BS"].ToString();
}
return(ObjList);
}
public ActionResult SaveDrs(FNM_AC_COA_VM FNM)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
FNM.COMPANY_UID = list[0].CmpyCode;
FNM.UserName = list[0].user_name;
return(Json(_FNM_AC_COAService.SaveFNM_AC_COA(FNM), JsonRequestBehavior.AllowGet));
}
}
public FNM_AC_COA_VM SaveFNM_AC_COA(FNM_AC_COA_VM FC)
{
return(_FNM_AC_COARep.SaveFNM_AC_COA(FC));
}
public FNM_AC_COA_VM SaveFNM_AC_COA(FNM_AC_COA_VM ac)
{
try
{
DateTime dte;
string dtstr1;
dte = Convert.ToDateTime(DateTime.Now.ToString());
dtstr1 = dte.ToString("yyyy-MM-dd hh:mm:ss tt");
if (!ac.EditFlag)
{
//var Drecord = new List<string>();
//FNM_AC_COA_VM ObjList = new FNM_AC_COA_VM();
// CMPYCODE = m.CMPYCODE,
// FNMBRANCH_CODE = m.FNMBRANCH_CODE,
// DESCRIPTION = m.DESCRIPTION,
// SNO = m.SNO,
// PRINTNAME = m.PRINTNAME,
// ADDRESS = m.ADDRESS,
// EMAIL = m.EMAIL,
// WEBSITE = m.WEBSITE,
// MOBILE = m.MOBILE,
// CURRENCY = m.CURRENCY,
// COUNTRY = m.COUNTRY,
// STATE = m.STATE
//int n = 0;
// n = ObjList.Count;
int Stats1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from FNM_AC_COA where CMPYCODE='" + ac.COMPANY_UID + "' and FNM_AC_COA_CODE='" + ac.CODE + "'");
if (Stats1 == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + ac.COMPANY_UID + "',");
sb.Append("'" + ac.CODE + "',");
sb.Append("'" + ac.NAME + "',");
sb.Append("'" + ac.Head_code + "',");
sb.Append("'" + ac.group_code + "',");
sb.Append("'" + ac.SUBGROUP_code + "',");
sb.Append("'" + ac.UserName + "',");
sb.Append("'" + dtstr1 + "',");
sb.Append("'" + ac.UserName + "',");
sb.Append("'" + dtstr1 + "',");
sb.Append("'" + ac.COA_TYPE + "',");
sb.Append("'" + ac.SUBLEDGER_TYPE + "',");
sb.Append("'" + ac.SUBLEDGER_CAT + "',");
sb.Append("'" + ac.MASTER_STATUS + "',");
sb.Append("'" + ac.NOTE + "',");
sb.Append("'" + ac.NATURE + "',");
sb.Append("'" + ac.Name_Arabic + "',");
sb.Append("'" + ac.FNMBRANCH_CODE + "',");
sb.Append("'" + ac.PL_BS + "')");
_EzBusinessHelper.ExecuteNonQuery("insert into FNM_AC_COA(CMPYCODE,FNM_AC_COA_CODE,NAME,Head_Code,group_code,SUBGROUP_code,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,COA_TYPE,SUBLEDGER_TYPE,SUBLEDGER_CAT,MASTER_STATUS,NOTE,NATURE,Name_Arabic,branchcode,PL_BS) values(" + sb.ToString() + "");
int pno = _EzBusinessHelper.ExecuteScalar("Select Nos from PARTTBL001 where CmpyCode='" + ac.COMPANY_UID + "' and Code='COA' ");
_EzBusinessHelper.ActivityLog(ac.COMPANY_UID, ac.UserName, "Add FNM_AC_COA", ac.CODE, Environment.MachineName);
_EzBusinessHelper.ExecuteNonQuery(" UPDATE PARTTBL001 SET Nos = " + (pno + 1) + " where CmpyCode='" + ac.COMPANY_UID + "' and Code='COA'");
ac.SaveFlag = true;
ac.ErrorMessage = string.Empty;
}
else
{
//Drecord.Add(branch.FNMBRANCH_CODE.ToString());
// branch.Drecord = Drecord;
ac.SaveFlag = false;
ac.ErrorMessage = "Duplicate Record";
}
return(ac);
}
var StatsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from FNM_AC_COA where CMPYCODE='" + ac.COMPANY_UID + "' and FNM_AC_COA_CODE='" + ac.CODE + "'and Flag=0");
if (StatsEdit != 0)
{
StringBuilder sb = new StringBuilder();
// sb.Append("'" + dtstr8 + "',");
sb.Append("NAME='" + ac.NAME + "',");
sb.Append("Head_Code='" + ac.Head_code + "',");
sb.Append("group_code='" + ac.group_code + "',");
sb.Append("SUBGROUP_code='" + ac.SUBGROUP_code + "',");
sb.Append("UPDATED_BY='" + ac.UserName + "',");
sb.Append("UPDATED_ON='" + dtstr1 + "',");
sb.Append("COA_TYPE='" + ac.COA_TYPE + "',");
sb.Append("SUBLEDGER_TYPE='" + ac.SUBLEDGER_TYPE + "',");
sb.Append("SUBLEDGER_CAT='" + ac.SUBLEDGER_CAT + "',");
sb.Append("NOTE='" + ac.NOTE + "',");
sb.Append("NATURE='" + ac.NATURE + "',");
sb.Append("Name_Arabic='" + ac.Name_Arabic + "',");
sb.Append("branchcode='" + ac.FNMBRANCH_CODE + "',");
sb.Append("PL_BS='" + ac.PL_BS + "'");
_EzBusinessHelper.ExecuteNonQuery("update FNM_AC_COA set " + sb + " where CMPYCODE='" + ac.COMPANY_UID + "' and FNM_AC_COA_CODE='" + ac.CODE + "' and Flag=0");
_EzBusinessHelper.ActivityLog(ac.COMPANY_UID, ac.UserName, "Update FNM_AC_COA", ac.CODE, Environment.MachineName);
ac.SaveFlag = true;
ac.ErrorMessage = string.Empty;
}
else
{
ac.SaveFlag = false;
ac.ErrorMessage = "Record not available";
}
}
catch (Exception ex)
{
ac.SaveFlag = false;
}
return(ac);
}
