public RateRow(RateType RateType, int ColumCount) { this.RateType = RateType; Columns = new List <RateColumn>(); CodeListBL CodeListBL = new CodeListBL(); for (int i = 0; i < ColumCount; i++) { var col = new RateColumn(RateType) { Id = i + 1 }; if (i == 0) { col.IsDropDown = true; col.DropDownType = ColumnDropDownType.Carrier; var list = CodeListBL.GetCarrierList(); foreach (var item in list) { col.DropDownItems.Add(new SelectListItem() { Text = item.Text, Value = item.Value }); } } if (i == 1 || i == 2) { col.IsDropDown = true; col.DropDownType = ColumnDropDownType.Port; var list = CodeListBL.GetPortList(); foreach (var item in list) { col.DropDownItems.Add(new SelectListItem() { Text = item.Text, Value = item.Value }); } } if (i == 3) { col.IsDropDown = true; } Columns.Add(col); } }
public RateHeaderRow(RateType RateType) { this.RateType = RateType; int ColumCount = 0; RateHeaderColumns = new List <RateHeaderColumn>(); CodeListBL CodeListBL = new CodeListBL(); if (RateType == CDT.RateType.CustomerSellingRate) { ColumCount = AppConstants.CustomerSellingRateHeaderColumCount; } if (RateType == CDT.RateType.AirLineBuyingRate) { ColumCount = AppConstants.AirLineBuyingRateHeaderColumCount; } if (RateType == CDT.RateType.AgentBuyingRate) { ColumCount = AppConstants.AgentBuyingRateHeaderColumCount; } if (RateType == CDT.RateType.IATARate) { ColumCount = AppConstants.IATARateHeaderColumnCount; } for (int i = 0; i < ColumCount; i++) { var col = new RateHeaderColumn(RateType) { Id = i + 1 }; if (RateType == CDT.RateType.CustomerSellingRate) { CreateCustomerSellingRateHeaderColums(RateType, ColumCount, CodeListBL, i, col); } if (RateType == CDT.RateType.AirLineBuyingRate) { CreateAirlineBuyingRateHeaderColums(RateType, ColumCount, CodeListBL, i, col); } if (RateType == CDT.RateType.AgentBuyingRate) { CreateAgentBuyingRateHeaderColums(RateType, ColumCount, CodeListBL, i, col); } if (RateType == CDT.RateType.IATARate) { CreateIATARateHeaderColums(RateType, ColumCount, CodeListBL, i, col); } } }
private void CreateIATARateHeaderColums(RateType RateType, int ColumCount, CodeListBL CodeListBL, int i, RateHeaderColumn col) { col.Text = ""; col.Value = ""; if (i == 2) { col.IsDropDown = true; col.DropDownType = ColumnDropDownType.Unit; col.DropDownItems.Add(new SelectListItem() { Text = "LB", Value = "L" }); col.DropDownItems.Add(new SelectListItem() { Text = "KG", Value = "K" }); } if (i == 0 || i == 1) { col.IsDropDown = true; col.DropDownType = ColumnDropDownType.Port; var list = CodeListBL.GetPortList(); foreach (var item in list) { col.DropDownItems.Add(new SelectListItem() { Text = item.Text, Value = item.Value }); } } if (i == 3) { col.IsMin = true; } if (i == ColumCount - 1) { col.IsProfitShare = true; } col.RateType = RateType; RateHeaderColumns.Add(col); }
private void GetIATARate(RateTable model) { model.RateRoutes.Clear(); RateManagementBL bl = new RateManagementBL(); List <RateRouting> routes = bl.GetRateRoutings(int.Parse(GetCurrentELTUser().elt_account_number), model.CustomerAccount, Convert.ToInt32(RateType.IATARate)); AddMinCol(routes); CodeListBL BL = new CodeListBL(); var list = BL.GetCarrierList(); foreach (var route in routes) { var info = bl.GetRouting(route.ID); RateRoute r = new RateRoute(RateType.IATARate) { RouteID = route.ID, Mode = RateRouteMode.Edit }; r.RouteID = route.ID; r.HeaderRow.RateType = RateType.IATARate; int data_start_index = AppConstants.IATARateHeaderColumnStartIndex; r.HeaderRow.RateHeaderColumns[0].Text = info.Origin; r.HeaderRow.RateHeaderColumns[1].Text = info.Dest; r.HeaderRow.RateHeaderColumns[2].Text = info.UnitText; r.HeaderRow.RateHeaderColumns[2].Value = info.Unit; bl.RefreshWeightBreakText(info.Rates[0].RateDefinitionColums); info.Rates[0].RateDefinitionColums = info.Rates[0].RateDefinitionColums.OrderBy(m => decimal.Parse(m.Value)).ToList(); for (int i = 0; i < info.Rates[0].RateDefinitionColums.Count; i++) { r.HeaderRow.RateHeaderColumns[data_start_index].Value = info.Rates[0].RateDefinitionColums[i].Value; r.HeaderRow.RateHeaderColumns[data_start_index].Text = info.Rates[0].RateDefinitionColums[i].Caption; data_start_index++; } foreach (var rate in route.Rates) { rate.RateDefinitionColums = rate.RateDefinitionColums.OrderBy(m => decimal.Parse(m.Value)).ToList(); data_start_index = AppConstants.IATARateDataColumnStartIndex; var data_row = new RateRow(RateType.IATARate, AppConstants.IATARateDataColumnCount); data_row.RouteId = route.ID; data_row.Id = rate.RateID; data_row.Columns[0].WeightBreakValueTag = "CarrierCode"; data_row.Columns[0].Value = rate.CarrierCode; data_row.Columns[0].Text = (from c in list where c.Value == rate.CarrierCode select c.Text).Single(); data_row.Columns[0].IsDropDown = true; data_row.Columns[0].DropDownType = ColumnDropDownType.Carrier; for (int i = 1; i < 2; i++) { data_row.Columns[i].IsDropDown = true; data_row.Columns[i].IsHidden = true; } foreach (var col in rate.RateDefinitionColums) { data_row.Columns[data_start_index].WeightBreakValueTag = col.Value; data_row.Columns[data_start_index].Value = col.Rate; data_row.Columns[data_start_index].Text = col.Rate; data_start_index++; } data_row.Columns[data_row.Columns.Count - 1].Text = rate.Share; data_row.Columns[data_row.Columns.Count - 1].Value = rate.Share; data_row.Columns[data_row.Columns.Count - 1].WeightBreakValueTag = "Share"; r.Rows.Add(data_row); } model.RateRoutes.Add(r); } foreach (var r in model.RateRoutes) { foreach (var row in r.Rows) { foreach (var col in row.Columns) { if (col.Text == null || col.Text == "") { if (col.Value == null || col.Value == "") { col.IsEmptyCell = true; } } } } } }