//ACCILEntities dba = new ACCILEntities();
public ActionResult Insert(int id = 0)
{
AccountMaster act = new AccountMaster();
List <SelectListItem> Type = new List <SelectListItem>();
Type.Add(new SelectListItem {
Text = "--Select--", Value = "-1"
});
ViewBag.FormReq = Type;
act.compcode = SessionMaster.CompCode;
if (id == 0)//Add Data in Account
{
var max = db.accounts.Max(i => i.acctcode);
act.acctcode = Convert.ToInt16(max) + 1;
}
else//Edit Data in Account
{
act.acctcode = id;
}
CompxERP.Models.clsSubmitModel oSubmit = new CompxERP.Models.clsSubmitModel();
DataTable dt;
dt = oSubmit.GetData("select * from usermenust where mencode =" + Request.QueryString["MenCode"] + " and menuser ="******"menaddi"]);
act.menedit = Convert.ToBoolean(dt.Rows[0]["menedit"]);
}
return(View(act));
}
public ActionResult CheckVoucher(string sVoucher, string MstType, int MstCode)
{
CompxERP.Models.clsSubmitModel oSubmit = new CompxERP.Models.clsSubmitModel();
DataTable dt2;
dt2 = oSubmit.GetData("select count(*) chno from jourmst where compcode = " + SessionMaster.CompCode + " and msttype = " + MstType + " and mstchno = '" + sVoucher + "' and mstcode <> " + MstCode, true);
return(Json(dt2.Rows[0]["chno"], JsonRequestBehavior.AllowGet));
}
public ActionResult Insert(account act, string command, AccountMaster oCls)
{
if (command == "Save")
{
CompxERP.Models.clsSubmitModel oSubmit = new CompxERP.Models.clsSubmitModel();
DataTable dt;
dt = oSubmit.GetData("select isnull(max(AcctCode) ,0 )+1 AcctCode from Account");
act.acctcode = Convert.ToInt32(dt.Rows[0]["AcctCode"]);
act.compcode = int.Parse(Session["CompCode"].ToString());
act.acctOwner = oCls.acctOwner;
act.acctcldr = 0;
act.acctclcr = 0;
act.acctjmbl = -1;
act.acctagen = 0;
act.acctrema = act.CSTNo + ',' + act.PAN + ',' + act.TinNo + ',' + act.acctrema;
act.acwithbl = 0;
act.acctitrd = 0;
act.acctdsap = 0;
act.acctprty = 0;
act.acctprbl = 0;
act.acFarmerDC = 0;
if (oCls.groumain == "9" || oCls.groumain == "10" || oCls.groumain == "40" || oCls.groumain == "41")
{
act.acctpinc = oCls.acctpinc_Hearder;
}
db.accounts.InsertOnSubmit(act);
db.SubmitChanges();
//********************************* User Work *********************************
clsUserWork oUser = new clsUserWork();
oUser.woruser = SessionMaster.UserID;
oUser.wormode = 0;
oUser.worcomp = SessionMaster.CompCode;
oUser.wortype = 0;
oUser.worcode = act.acctcode;
oUser.worsrno = oSubmit.GetUsWoCode();;
oUser.worrema = "D-" + oCls.acctname + "#" + oCls.acctgroup + "#" + oCls.acctphon;
oUser.wordate = Convert.ToDateTime("04/01/1900");
oUser.worrfsr = "";
oUser.worsysn = Environment.MachineName;
oSubmit.InsUserWork(oUser);
//***************************************************************************
TempData["Msg"] = "Data Save Successfully";
return(RedirectToAction("Insert"));
}
else
{
clsSubmitModel oSubmit = new clsSubmitModel();
var res = from k in db.accounts where k.acctcode == act.acctcode select k;
account temp = new account();// db.accounts.First(m => m.acctcode == id);
switch (act.acctgrou)
{
case 34: //Agent
break;
case 24: //Bank
act.acctarea = 0;
act.acctcity = 0;
act.acctstat = 0;
break;
}
temp.acctOwner = act.acctOwner;
temp.acctgsta = act.acctgsta;
temp.acctgstin = act.acctgstin;
temp.acctname = act.acctname;
temp.acctgrou = act.acctgrou;
temp.acctcode = act.acctcode;
temp.acctalia = act.acctalia;
temp.acctrema = act.CSTNo + ',' + act.PAN + ',' + act.TinNo + ',' + act.acctrema;
temp.acctsort = act.acctsort;
temp.acctconp = act.acctconp;
temp.acctdsa = act.acctdsa;
temp.TinNo = act.TinNo;
temp.PAN = act.PAN;
temp.CSTNo = act.CSTNo;
temp.acctPhone = act.acctPhone;
temp.acctMob2 = act.acctMob2;
temp.acctphon = act.acctphon;
temp.accthind = act.accthind;
temp.acctaddr = act.acctaddr;
temp.acctarea = act.acctarea;
temp.acctcity = act.acctcity;
temp.acctstat = act.acctstat;
temp.acctledg = act.acctledg;
temp.PIN = act.PIN;
temp.acctconp = act.acctconp;
temp.acctcurr = act.acctcurr;
temp.acctcate = act.acctcate;
temp.acctpinc = act.acctpinc;
temp.acctmail = act.acctmail;
temp.acctfax = act.acctfax;
temp.acctjmbl = act.acctjmbl; //-1
temp.acctagen = act.acctagen;
temp.acctitrd = act.acctitrd; //0;
temp.acctrate = act.acctrate; //0
temp.acformreq = act.acformreq;
temp.acwithbl = 0;
temp.acctcldr = 0;
temp.acctclcr = 0;
temp.acctprty = 0;
temp.acctprbl = 0;
temp.acFarmerDC = 0;
temp.acctdsap = 0;
if (oCls.groumain == "9" || oCls.groumain == "10" || oCls.groumain == "40" || oCls.groumain == "41")
{
temp.acctpinc = oCls.acctpinc_Hearder;
}
temp.compcode = Convert.ToInt32(Session["compcode"]);
oSubmit.UpdAccount(temp);
//********************************* User Work *********************************
clsUserWork oUser = new clsUserWork();
oUser.woruser = SessionMaster.UserID;
oUser.wormode = 1;
oUser.worcomp = SessionMaster.CompCode;
oUser.wortype = 0;
oUser.worcode = act.acctcode;
oUser.worsrno = oSubmit.GetUsWoCode();;
oUser.worrema = "D-" + oCls.acctname + "#" + oCls.acctgroup + "#" + oCls.acctphon;
oUser.wordate = Convert.ToDateTime("04/01/1900");//DateTime.Now.Date;
oUser.worrfsr = "";
oUser.worsysn = Environment.MachineName;
oSubmit.InsUserWork(oUser);
//***************************************************************************
TempData["Msg"] = "Updated Successfully";
return(RedirectToAction("Insert"));
}
}
public ActionResult Create(int comp = 0, int id = 0, int mstCode = 0, int MstType = 0, int mstcode_Print = 0, int MenCode = 0)
{
if (mstcode_Print == 0)
{
TempData["message"] = null;
}
//TempData["CurrentCulture"] = Session["CurrentCulture"];
comp = Convert.ToInt32(SessionMaster.CompCode);
if (comp == 0)
{
Response.Redirect("~/Index/Index");
//TempData["message"] = "Please Select Company ...";
}
CompxERP.Models.clsSubmitModel oSubmit = new CompxERP.Models.clsSubmitModel();
ViewBag.MstType = Request.QueryString["MstType"];
Jourmaster frm = new Jourmaster();
//************************** Rights ****************************
DataTable dt;
dt = oSubmit.GetData("select * from usermenust where mencode =" + Request.QueryString["MenCode"] + " and menuser ="******"menview"]) == false) Response.Redirect("../home/menuNew");
// frm.menaddi = Convert.ToBoolean(dt.Rows[0]["menaddi"]);
// frm.menedit = Convert.ToBoolean(dt.Rows[0]["menedit"]);
// frm.menview = Convert.ToBoolean(dt.Rows[0]["menview"]);
// frm.mencode = Convert.ToInt32(dt.Rows[0]["menCode"]);
// ViewBag.MenCode = frm.mencode;
//}
//**************************************************************
if (MstType == 3)
{
frm.Header = "Receipt Entry";
}
else if (MstType == 5)
{
if (Session["CurrentCulture"].ToString() == "1" || Session["CurrentCulture"].ToString() == "0")
{
frm.Header = "Payment Entry"; //else frm.Header = "إدخال الدفع";
}
}
else if (MstType == 6)
{
frm.Header = "Journal Voucher";
}
else if (MstType == 108)
{
frm.Header = "Contra Entry";
}
else
{
frm.Header = "";
}
if (mstCode > 0)
{
#region "Edit"
dt = oSubmit.GetVoucher(MstType, comp, mstCode);
if (dt.Rows.Count > 0)
{
ViewBag.MstType = frm.msttype = Convert.ToInt32(dt.Rows[0]["MstType"]);
frm.compcode = Convert.ToInt32(dt.Rows[0]["Compcode"]);
ViewBag.MstCode = frm.mstcode = Convert.ToInt32(dt.Rows[0]["mstCode"]);
frm.mstdate = Convert.ToDateTime(dt.Rows[0]["mstDate"]);
frm.ChallanDate = Convert.ToDateTime(dt.Rows[0]["mstdate"]).ToString("dd/MM/yyyy");
if (dt.Rows[0]["mstpdc"].ToString() != "")
{
frm.mstpdc = Convert.ToInt32(dt.Rows[0]["mstpdc"]);
if (frm.mstpdc == 1)
{
frm.IsPostDt = true;
}
else
{
frm.IsPostDt = false;
}
}
if (dt.Rows[0]["mstactpay"].ToString() != "")
{
frm.mstactpay = Convert.ToInt32(dt.Rows[0]["mstactpay"]);
if (frm.mstactpay == 1)
{
frm.IsAcctPay = true;
}
else
{
frm.IsAcctPay = false;
}
}
if (dt.Rows[0]["mstchqadj"].ToString() != "")
{
frm.mstchqadj = Convert.ToInt32(dt.Rows[0]["mstchqadj"]);
}
if (dt.Rows[0]["mststat"].ToString() != "")
{
frm.mststat = Convert.ToInt32(dt.Rows[0]["mststat"]);
}
if (dt.Rows[0]["msttime"].ToString() != "")
{
frm.msttime = Convert.ToInt32(dt.Rows[0]["msttime"]);
}
//frm.msttimes = frm.msttime.ToString();
if (dt.Rows[0]["msttota"].ToString() != "")
{
frm.msttota = Convert.ToInt32(dt.Rows[0]["msttota"]);
}
frm.mstrema = dt.Rows[0]["mstrema"].ToString();
frm.mstchno = dt.Rows[0]["mstchno"].ToString();
if (dt.Rows[0]["mstneta"].ToString() != "")
{
frm.mstneta = Convert.ToInt32(dt.Rows[0]["mstneta"]);
}
frm.mstclno = dt.Rows[0]["mstclno"].ToString();
frm.mstchnm = dt.Rows[0]["mstchnm"].ToString();
frm.IsEdit = true;
if (frm.mstchqadj == 1)
{
frm.IsChqAdj = true;
}
else
{
frm.IsChqAdj = false;
}
return(View("Create", frm));
}
#endregion
}
else
{
#region "Create"
var res = from k in db.accounts where k.compcode == (6) select k;
ViewBag.tpPartyID = new SelectList(res, "acctcode", "acctname");
//var comdt = from k in db.companies where k.compcode == 6 select new { k.compopdt };
//dt = oSubmit.GetData("select compopdt from company where compcode =6");
//frm.msttimes = DateTime.Now.ToString("HH:mm:ss");
DataTable dt2;
string sMstChNo = DateTime.Now.Date.Date.ToString("yy") + DateTime.Now.Date.Date.ToString("MM") + DateTime.Now.Date.Date.ToString("dd");
dt2 = oSubmit.GetData("SELECT ISNULL(MAX(mstcode)+1 ,1)mstcode from jourmst where compcode ='" + comp + "' and msttype ='" + MstType + "'", true);
ViewBag.MstCode = frm.mstcode = Convert.ToInt32(dt2.Rows[0]["mstcode"]);
dt2 = oSubmit.GetData("select isnull(max(right(mstchno,2))+1,1) as maxchno from jourmst where compcode = " + comp + " and msttype = " + MstType + " and left(mstchno, 6) = '" + sMstChNo + "'", true);
ViewBag.mstchno = frm.mstchno = sMstChNo + GetVoucherNo(dt2.Rows[0]["maxchno"].ToString());
frm.compcode = Convert.ToInt32(SessionMaster.CompCode);
frm.type = MstType;
frm.mstdate = DateTime.Now.Date;
frm.ChallanDate = DateTime.Now.Date.ToString("dd/MM/yyyy");
frm.mstcode_Print = mstcode_Print;
frm.IsEdit = false;
#endregion
}
return(View("Create", frm));
}
