private IEnumerable <ShipmentkeyModel> GetShipmentKeys(int weekId)
        {
            var shipmentkeyModels = DB.ShipmentKeys(weekId);

            ShipmentKeys = shipmentkeyModels.ToList();
            return(shipmentkeyModels);
        }
        private void GetShipmentkey(int ShipTo, int ShipmentModeID, int Port, DateTime ShipmentDate, int PriceTerm, int WeeklyProductionCapacity)
        {
            List <ShipmentkeyModel> shipmentkeyModels = DB.ShipmentKeys(WeeklyProductionCapacity);
            var shipmentkey = shipmentkeyModels.Where(o => o.ShipTo == ShipTo && o.ShipmentModeID == ShipmentModeID && o.PortID == Port && o.ShipmentDate == ShipmentDate && o.PriceTermID == PriceTerm).FirstOrDefault();

            litShipToTable.Text          = shipmentkey.CompanyName;
            litDestinationPortTable.Text = shipmentkey.DestinationPort;
            litETDTable.Text             = shipmentkey.ShipmentDate.ToString("dd MMMM yyyy");
            litPriceTermTable.Text       = shipmentkey.PriceTerm;
            litQtyTable.Text             = shipmentkey.Qty.ToString();
        }