// GET: /Tran/Create
        public ActionResult Create()
        {
            ViewBag.AgentID         = new SelectList(db.Agent, "AgentID", "AgentName");
            ViewBag.CommodityID     = new SelectList(db.Commodity, "CommodityID", "CommodityName");
            ViewBag.OriginCountryID = new SelectList(db.Country, "CountryID", "CountryName");
            ViewBag.ConsigneeID     = new SelectList(db.Customer, "CustomerID", "CustomerName");
            ViewBag.ShipperID       = new SelectList(db.Customer, "CustomerID", "CustomerName");
            ViewBag.CourierID       = new SelectList(db.Courier, "CourierID", "CourierName");
            ViewBag.SalesManID      = new SelectList(db.SalesMan, "SalesManID", "SalesManName");
            ViewBag.ShippingTermID  = new SelectList(db.ShippingTerm, "ShippingTermID", "ShippingTermName");
            ViewBag.ShippingTypeID  = new SelectList(db.ShippingType, "ShippingTypeID", "ShippingTypeName");

            ViewBag.POL = new SelectList(db.Port, "PortID", "PortName");
            ViewBag.POD = new SelectList(db.Port, "PortID", "PortName");
            try
            {
                int salesmanID = SalesManLogic.GetSalesManID(User.Identity.Name);
                ViewBag.CurrentSalesManName = db.SalesMan.FirstOrDefault(s => s.SalesManID == salesmanID).SalesManName;
            }
            catch
            {
                ViewBag.CurrentSalesManName = "none";
            }

            // zaatar
            ViewBag.countryList = new SelectList(db.Country.AsEnumerable(), "CountryID", "CountryName", "-- Select Agent Country --");//db.Country.ToList();


            ViewBag.ShippingTypes = db.ShippingType.ToList();
            return(View());
        }
        public ActionResult Create([Bind(Include = "TranID,Updated,Updator,TranRefNumber,ReservationDate,BookingDate,BLNo,ShipperID,ConsigneeID,PhoneNumber,AgentID,SalesManID,ShippingTypeID,ShippingTypeNumbers,CommodityID,ShippingTermID,OriginCountryID,POL,POD,ETD,ETA,TT,FinalDistination,Notes,CourierID")] Tran tran)
        {
            tran.TranRefNumber = Helpers.CreateTranRefNumber();

            //get sales man ID to be saved in the tran.SalesManID
            if (tran.SalesManID == null)
            {
                tran.SalesManID = SalesManLogic.GetSalesManID(User.Identity.Name);
            }

            if (ModelState.IsValid)
            {
                db.Tran.Add(tran);
                db.SaveChanges();
                BusinessLogic.Calculations.CalcTran(tran.TranID, 6);
                //BusinessLogic.Calculations.CalcTotals(tran.TranID);
                return(RedirectToAction("Index"));
            }

            ViewBag.AgentID         = new SelectList(db.Agent, "AgentID", "AgentName", tran.AgentID);
            ViewBag.CommodityID     = new SelectList(db.Commodity, "CommodityID", "CommodityName", tran.CommodityID);
            ViewBag.OriginCountryID = new SelectList(db.Country, "CountryID", "CountryName", tran.OriginCountryID);
            ViewBag.ConsigneeID     = new SelectList(db.Customer, "CustomerID", "CustomerName", tran.ConsigneeID);
            ViewBag.ShipperID       = new SelectList(db.Customer, "CustomerID", "CustomerName", tran.ShipperID);
            ViewBag.CourierID       = new SelectList(db.Courier, "CourierID", "CourierName", tran.CourierID);
            ViewBag.SalesManID      = new SelectList(db.SalesMan, "SalesManID", "SalesManName", tran.SalesManID);
            ViewBag.ShippingTermID  = new SelectList(db.ShippingTerm, "ShippingTermID", "ShippingTermName", tran.ShippingTermID);
            // ZAATAR-MULTIST ViewBag.ShippingTypeID = new SelectList(db.ShippingType, "ShippingTypeID", "ShippingTypeName", tran.ShippingTypeID);

            ViewBag.POL = new SelectList(db.Port, "PortID", "PortName", tran.POL);
            ViewBag.POD = new SelectList(db.Port, "PortID", "PortName", tran.POD);


            // zaatar
            ViewBag.countryList = new SelectList(db.Country.AsEnumerable(), "CountryID", "CountryName", "-- Select Agent Country --");//db.Country.ToList();


            try
            {
                int salesmanID = SalesManLogic.GetSalesManID(User.Identity.Name);
                ViewBag.CurrentSalesManName = db.SalesMan.FirstOrDefault(s => s.SalesManID == salesmanID).SalesManName;
            }
            catch
            {
                ViewBag.CurrentSalesManName = "none";
            }


            return(View(tran));
        }