public ActionResult EditForm() { var id = Session["id"]; if (id == null) { return(RedirectToAction("Index", "Login")); } else { var formid = Request.QueryString["formid"]; int ids = 0; OemahJowoClass formfield = new OemahJowoClass(); if (!string.IsNullOrEmpty(formid)) { ids = Convert.ToInt32(formid); var formhdr = db.mt_trans_hdr.Find(ids); formfield.transhdr = formhdr; if (formhdr != null) { formfield.TRANS_DATE = formhdr.TRANS_DATE; formfield.TRANS_DATE_STR = formhdr.TRANS_DATE.ToString("M/d/yyyy"); formfield.DESCRIPTION = formhdr.DESCRIPTION; formfield.CUST_ID = formhdr.CUST_ID; Session["FormDtls"] = formhdr.mt_trans_dtl.ToList(); } } var dtCust = db.mt_customer.OrderBy(y => y.CUST_NAME).ToList(); formfield.custDD = dtCust; return(View(formfield)); } }
public ActionResult Index() { ViewBag.Loggeduser = Session["id"]; if (Session["id"] != null) { OemahJowoClass dropdownDt = new OemahJowoClass(); List <homeCls> dt = new List <homeCls>(); homeCls val1 = new homeCls(); val1.total = 5; val1.totalstr = "5"; dt.Add(val1); homeCls val2 = new homeCls(); val2.total = 10; val2.totalstr = "10"; dt.Add(val2); homeCls val3 = new homeCls(); val3.total = 15; val3.totalstr = "15"; dt.Add(val3); homeCls val4 = new homeCls(); val4.total = 20; val4.totalstr = "20"; dt.Add(val4); dropdownDt.ddValDt = dt; return(View(dropdownDt)); } else { return(RedirectToAction("Index", "Login")); } }
// GET: CustomerRpt public ActionResult Index() { var id = Session["id"]; if (id == null) { return(RedirectToAction("Index", "Login")); } else { OemahJowoClass fld = new OemahJowoClass(); List <custcat> catfld = new List <custcat>(); custcat fld1 = new custcat(); fld1.catid = "ALL"; fld1.catname = "ALL"; catfld.Add(fld1); custcat fld2 = new custcat(); fld2.catid = "GOJEK"; fld2.catname = "GOJEK"; catfld.Add(fld2); custcat fld3 = new custcat(); fld3.catid = "GRAB"; fld3.catname = "GRAB"; catfld.Add(fld3); fld.custcatdt = catfld; return(View(fld)); } }
public ActionResult PrintPdfCust(OemahJowoClass obj) { var filter = obj.catfilter; return(new Rotativa.MVC.ActionAsPdf("CustRptPdf", new { filters = filter }) { FileName = "CustomerList.pdf", RotativaOptions = new Rotativa.Core.DriverOptions { PageOrientation = Rotativa.Core.Options.Orientation.Portrait } }); }
public ActionResult TransRptPdf(string froms, string tos) { OemahJowoClass form = new OemahJowoClass(); List <TransRptField> transDt = new List <TransRptField>(); var datefrom = froms; var dateto = tos; var date = DateTime.Now; DateTime from = new DateTime(date.Year, date.Month, 1); DateTime to = from.AddMonths(1).AddDays(-1); if (!string.IsNullOrEmpty(datefrom) && !string.IsNullOrEmpty(dateto)) { from = Convert.ToDateTime(datefrom); to = Convert.ToDateTime(dateto); } var datediff = to - from; var shopcatdt = db.mg_shoplist.Where(y => y.TRANS_DATE >= from && y.TRANS_DATE <= to).ToList(); var incomedt = db.mt_trans_hdr.Where(y => y.TRANS_DATE >= from && y.TRANS_DATE <= to).ToList(); for (int i = 0; i <= datediff.Days; i++) { var datenows = from.AddDays(i); var shopcatfield = shopcatdt.Where(y => y.TRANS_DATE == datenows).ToList(); var incomefield = incomedt.Where(y => y.TRANS_DATE == datenows).ToList(); foreach (var dt in incomefield) { var price = dt.mt_trans_dtl.Sum(y => y.PRICE); TransRptField field = new TransRptField(); field.TRANS_DATE = datenows; field.DESCRIPTION = dt.DESCRIPTION; field.debit = price; field.CUST_NAME = dt.mt_customer?.CUST_NAME; field.phone = dt.mt_customer?.PHONE; transDt.Add(field); } foreach (var dt in shopcatfield) { TransRptField field = new TransRptField(); field.TRANS_DATE = datenows; field.DESCRIPTION = dt.NOTES; field.credit = dt.AMOUNT; field.CUST_NAME = null; field.phone = null; transDt.Add(field); } } transDt = transDt.OrderBy(y => y.TRANS_DATE).ToList(); form.transrptdt = transDt; //dashboardcosts = dashboardcosts.OrderBy(y => y.Monthyear).ToList(); return(View(form)); }
public ActionResult Insert(OemahJowoClass transDt) { var userobject = Session["id"]; if (userobject == null) { return(RedirectToAction("Index", "Login")); } else { transDt.TRANS_DATE = Convert.ToDateTime(transDt.TRANS_DATE.ToString("MM/dd/yyyy")); var editmode = Request.QueryString["editmode"]; var username = User.Identity.Name; transDt.ENTRY_DATE = DateTime.Now; transDt.ENTRY_USER = userobject.ToString(); transDt.UPDATE_DATE = DateTime.Now; transDt.UPDATE_USER = userobject.ToString(); var dtname = username; using (db) { try { mt_transaction transfield = new mt_transaction(); transfield.TRANS_DATE = transDt.TRANS_DATE; transfield.PROD_ID = transDt.PROD_ID; transfield.DESCRIPTION = transDt.DESCRIPTION; transfield.CUST_ID = transDt.CUST_ID; transfield.ITEM_AMT = transDt.ITEM_AMT; transfield.PRICE = transDt.PRICE; if (transDt.IS_ONLINE) { transfield.IS_GOJEK = "Y"; } else { transfield.IS_GOJEK = "N"; } transfield.UPDATE_DATE = transDt.UPDATE_DATE; transfield.UPDATE_USER = transDt.UPDATE_USER; transfield.ENTRY_DATE = transDt.ENTRY_DATE; transfield.ENTRY_USER = transDt.ENTRY_USER; db.mt_transaction.Add(transfield); db.SaveChanges(); return(Json(new { success = true, message = "Saved successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { success = false, message = e.InnerException.Message }, JsonRequestBehavior.AllowGet)); } } } }
public ActionResult PrintPdfTrans(OemahJowoClass obj) { var from = obj.datefromstr; var to = obj.datetostr; return(new Rotativa.MVC.ActionAsPdf("TransRptPdf", new { froms = from, tos = to }) { FileName = "TransactionRpt.pdf", RotativaOptions = new Rotativa.Core.DriverOptions { PageOrientation = Rotativa.Core.Options.Orientation.Landscape } }); }
public ActionResult AddForm() { var id = Session["id"]; if (id == null) { return(RedirectToAction("Index", "Login")); } else { OemahJowoClass formfield = new OemahJowoClass(); Session["FormDtls"] = new List <mt_trans_dtl>(); var dtCust = db.mt_customer.OrderBy(y => y.CUST_NAME).ToList(); formfield.custDD = dtCust; return(View(formfield)); } }
public ActionResult CustRpt() { string category = ""; var catselect = Request.QueryString["category"]; if (!string.IsNullOrEmpty(catselect)) { if (catselect == "GOJEK") { category = "GF"; } else if (catselect == "GRAB") { category = "GRB"; } } else { category = ""; } OemahJowoClass field = new OemahJowoClass(); List <mt_customer> custDt = new List <mt_customer>(); var dt = db.mt_customer.OrderBy(y => y.CUST_NAME).ToList(); if (!string.IsNullOrEmpty(category)) { foreach (var dts in dt) { var transdt = dts.mt_trans_hdr.ToList(); var forms = transdt.Where(str => category.All(str.DESCRIPTION.Contains)).ToList(); if (forms.Count() > 0) { custDt.Add(dts); } } } else { custDt = dt; } field.custDD = custDt; return(PartialView(field)); }
public ActionResult AddorEdit(string transid) { var id = Session["id"]; if (id == null) { return(RedirectToAction("Index", "Login")); } else { OemahJowoClass formfield = new OemahJowoClass(); formfield.TRANS_DATE = DateTime.Now; var dtProd = db.mt_prod.OrderBy(y => y.PROD_NAME).ToList(); var dtCust = db.mt_customer.OrderBy(y => y.CUST_NAME).ToList(); formfield.custDD = dtCust; formfield.prodDD = dtProd; return(View(formfield)); } }
public ActionResult TransactionFormPartial(string command) { OemahJowoClass Hdr = new OemahJowoClass(); List <mt_trans_dtl> p = Session["FormDtls"] as List <mt_trans_dtl>; string[] results = command.Split(';'); string action = results[0]; int index = Convert.ToInt32(results[1]); if (action == "add") { p.Add(new mt_trans_dtl()); } else { p.RemoveAt(index); //var idDelete = Request.QueryString["deleteid"]; //if (!string.IsNullOrEmpty(idDelete)) //{ // var id = Convert.ToDecimal(idDelete); // if (id != 0) // { // List<mt_trans_dtl> dtForm = Session["FormDtls"] as List<mt_trans_dtl>; // var removeField = dtForm.Where(y => y.DTL_ID == id).FirstOrDefault(); // dtForm.Remove(removeField); // } //} } Hdr.transDtl = p; var dtProd = db.mt_prod.OrderBy(y => y.PROD_NAME).ToList(); Hdr.prodDD = dtProd; return(PartialView(Hdr)); }