public ActionResult Index() { CompxERP.Models.clsSubmitModel oSubmit = new CompxERP.Models.clsSubmitModel(); DataTable dt; int comp = Convert.ToInt32(SessionMaster.CompCode); if (comp == 0) { //Response.Redirect("~/Index/Index"); //TempData["message"] = "Please Select Company ..."; } dt = oSubmit.GetVoucher(Convert.ToInt32(Request.QueryString["MstType"]), Convert.ToInt32(SessionMaster.CompCode)); ViewBag.MstType = Request.QueryString["MstType"]; ViewBag.MenCode = Request.QueryString["mencode"]; Jourmaster oModel = new Jourmaster(); List <CompxERP.Models.Jourmaster> oList = new List <CompxERP.Models.Jourmaster>(); for (int i = 0; i < dt.Rows.Count; i++) { oModel = new Models.Jourmaster(); oModel.mstcode = Convert.ToInt32(dt.Rows[i]["mstcode"]); oModel.mstdate = Convert.ToDateTime(dt.Rows[i]["mstdate"]); oModel.ChallanDate = Convert.ToDateTime(dt.Rows[i]["mstdate"]).ToString("dd/MM/yyyy"); oModel.msttota = Convert.ToDecimal(dt.Rows[i]["msttota"]); oModel.mstchno = dt.Rows[i]["mstChno"].ToString(); oModel.mstrema = dt.Rows[i]["mstrema"].ToString(); oModel.mstclno = dt.Rows[i]["mstclno"].ToString(); oModel.mstchnm = dt.Rows[i]["mstchnm"].ToString(); oModel.compcode = Convert.ToInt32(dt.Rows[i]["compcode"]); oModel.msttype = Convert.ToInt32(dt.Rows[i]["msttype"]); oList.Add(oModel); } oModel.ListArea = oList; return(View(oModel)); }
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)); }
//[HttpPost] //public ActionResult Create(Jourmaster oCls, string Action) //{ // if (Action.Equals("Save")) // { // Save(oCls); // } // else if (Action.Equals("Prev")) // { // PrevNext(oCls.compcode, oCls.mstcode - 1, oCls.mstcode - 1, oCls.msttype); // } // else if (Action.Equals("Next")) // { // PrevNext(oCls.compcode, oCls.mstcode + 1, oCls.mstcode + 1, oCls.msttype); // } // return View(); //} //[HttpPost] //public ActionResult Save(Jourmaster oCls) //{ // clsSubmitModel oSubmit = new clsSubmitModel(); // commFunction oCom = new commFunction(); // try // { // var json = oCls.sJourTrn; // clsPoItem ItemDet = JsonConvert.DeserializeObject<clsPoItem>(json); // ViewBag.MstType = oCls.msttype; // if (oCls.IsPostDt == true) oCls.mstpdc = 1; else oCls.mstpdc = 0; // if (oCls.IsAcctPay == true) oCls.mstactpay = 1; else oCls.mstactpay = 0; // if (oCls.IsChqAdj == true) oCls.mstchqadj = 1; else oCls.mstchqadj = 0; // oCls.mststat = 0; // //oCls.msttime = Convert.ToInt32(oCls.msttimes.ToString().Replace(":", "")); // oCls.mstrefc = getParty(Convert.ToInt32(oCls.mstprtc)) + "~0~0~0"; // oCls.mstdate = oSubmit.GetDateFormat(oCls.ChallanDate); // oSubmit.BeginTran(); // oSubmit.InsJourmst(oCls); // if (oCls.IsEdit != true) // { // oCls.StDate = Convert.ToDateTime(oCom.getOpenDate(DateTime.Now.Date)); // oCls.LastDate = Convert.ToDateTime(oCom.getClosDate(DateTime.Now.Date)); // oSubmit.UpdCodeGen(oCls); // } // jourtrn oTrn = new jourtrn(); // oSubmit.insertData("delete from jourtrn where compcode = " + oCls.compcode + " and trntype = " + oCls.msttype + " and trncode = " + oCls.mstcode); // for (int i = 0; i < ItemDet.LstItem.Count; i++) // { // oTrn.compcode = Convert.ToInt16(oCls.compcode); // oTrn.trntype = Convert.ToInt32(oCls.msttype); // oTrn.trncode = Convert.ToInt32(oCls.mstcode); // oTrn.trntime = Convert.ToInt32(oCls.msttime); // oTrn.trnsrno = Convert.ToInt16(i + 1); // oTrn.trndate = Convert.ToDateTime(oCls.mstdate); // oTrn.trnledg = oTrn.trnitem = Convert.ToInt32(ItemDet.LstItem[i].tpPartyID); // oTrn.trndram = Convert.ToInt32(ItemDet.LstItem[i].tpDrAmt); // oTrn.trncram = Convert.ToInt32(ItemDet.LstItem[i].tpCrAmt); // oTrn.trnrema = ItemDet.LstItem[i].Remark.ToString(); // oSubmit.InsJourTrn(oTrn); // } // oSubmit.Commit(); // TempData["message"] = "Saved Successfully ..."; // oCls.mstcode = 0; // } // catch (Exception ex) // { // oSubmit.RollBack(); // TempData["message"] = ex.Message; // return View(); // } // return RedirectToAction("Create", new { MstType = oCls.msttype, MstCode = oCls.mstcode, comp = oCls.compcode }); //} public ActionResult PrevNext(int comp = 0, int mstCode = 0, int MstType = 0, bool IsNext = true) { if (Convert.ToInt16(SessionMaster.CompCode) == 0) { Response.Redirect("~/Index/Index"); } string MSG = ""; if (IsNext == true) { mstCode = mstCode + 1; } else { mstCode = mstCode - 1; } //DBEntity oDB = new DBEntity(); comp = Convert.ToInt32(SessionMaster.CompCode); if (comp == 0) { TempData["message"] = "Please Select Company ..."; } CompxERP.Models.clsSubmitModel oSubmit = new CompxERP.Models.clsSubmitModel(); Jourmaster frm = new Jourmaster(); frm.mstcode = mstCode; frm.msttype = MstType; frm.compcode = comp; DataTable dt; dt = oSubmit.GetVoucher(MstType, comp, mstCode); if (mstCode > 0) { 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(); if (frm.mstchqadj == 1) { frm.IsChqAdj = true; } else { frm.IsChqAdj = false; } } else { var MaxMstCode = 0; MaxMstCode = (db.jourmsts.Where(x => x.compcode == SessionMaster.CompCode).Where(x => x.msttype == MstType).Max(x => x.mstcode)); if (mstCode > MaxMstCode) { frm.MSG = "This is last record ..."; } else { frm.MSG = "Record Not Found ..."; } } } else { frm.MSG = "This is First record ..."; } return(Json(Json(frm).Data, JsonRequestBehavior.AllowGet)); }