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