public ActionResult GetTranProfit(string fromDate, string toDate) { DateTime from = DateTime.Parse(fromDate); DateTime to = DateTime.Parse(toDate); var trans = db.Tran.Where(s => s.BookingDate > from && s.BookingDate < to) .ToList(); ProfitForTranListViewModel p = new ProfitForTranListViewModel(trans); ViewBag.fromDate = from; ViewBag.toDate = to; return PartialView("TranProfitDetailsList", p); }
/// <summary> /// /// </summary> /// <param name="id">Customer ID</param> public ProfitForCustomerViewModel(int id) { using (FFAdminDBEntities db = new FFAdminDBEntities()) { this.Customer = db.Customer.Find(id); if (Customer != null) { TranList = new ProfitForTranListViewModel( db.Tran.Where(s => s.ConsigneeID == Customer.CustomerID) .Select(s => s.TranID).ToList() ); } } }
/// <summary> /// /// </summary> /// <param name="id">Customer ID</param> public ProfitForCustomerViewModel(int id) { using (FFAdminDBEntities db = new FFAdminDBEntities()) { this.Customer = db.Customer.Find(id); if (Customer != null) { TranList = new ProfitForTranListViewModel( db.Tran.Where(s => s.ConsigneeID == Customer.CustomerID) .Select(s=> s.TranID).ToList() ); } } }