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