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