public List <FlattenRateItem> GetAllRate(int elt_account_number, int customer_org_num, int rate_type) { SqlConnection conn = new SqlConnection(GetConnectionString(AppConstants.DB_CONN_PROD)); SqlCommand cmd = new SqlCommand() { Connection = conn, CommandType = CommandType.StoredProcedure, CommandText = "dbo.[GetAllRate]" }; List <FlattenRateItem> list = new List <FlattenRateItem>(); try { cmd.Parameters.Add(new SqlParameter("@elt_account_number", elt_account_number)); cmd.Parameters.Add(new SqlParameter("@org_account_number", customer_org_num)); cmd.Parameters.Add(new SqlParameter("@rate_type", rate_type)); conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var item = new FlattenRateItem() { id = Convert.ToInt32(reader["id"]), elt_account_number = Convert.ToInt32(reader["elt_account_number"]), item_no = Convert.ToInt32(reader["item_no"]), rate_type = Convert.ToInt32(reader["rate_type"]), agent_no = reader["agent_no"].GetType() == typeof(System.DBNull) ?0: Convert.ToInt32(reader["agent_no"]), customer_no = reader["customer_no"].GetType() == typeof(System.DBNull) ? 0 : Convert.ToInt32(reader["customer_no"]), carrier = Convert.ToInt32(reader["airline"]), origin_port = Convert.ToString(reader["origin_port"]), dest_port = Convert.ToString(reader["dest_port"]), weight_break = Convert.ToString(reader["weight_break"]), rate = Convert.ToDecimal(reader["rate"]), kg_lb = Convert.ToString(reader["kg_lb"]), share = Convert.ToInt32(reader["share"]), is_org_merged = Convert.ToString(reader["is_org_merged"]), fl_rate = Convert.ToString(reader["fl_rate"]), sec_rate = Convert.ToString(reader["sec_rate"]), include_fl_rate = Convert.ToString(reader["include_fl_rate"]), include_sec_rate = Convert.ToString(reader["include_sec_rate"]), dba_name = Convert.ToString(reader["dba_name"]) }; list.Add(item); } } } catch (Exception ex) { throw ex; } finally { conn.Close(); conn.Dispose(); } return(list); }
public List <RateRouting> SaveRateInfo(List <RateRouting> rRList) { List <FlattenRateItem> list = new List <FlattenRateItem>(); int item_no = 0; foreach (var routing in rRList) { foreach (var rate in routing.Rates) { foreach (var br in rate.RateDefinitionColums) { if (!string.IsNullOrEmpty(br.Rate) && !string.IsNullOrEmpty(rate.CarrierCode) && !string.IsNullOrEmpty(routing.Origin) && !string.IsNullOrEmpty(routing.Dest)) { FlattenRateItem item = new FlattenRateItem(); item.rate_type = rate_type; item.item_no = item_no; item.weight_break = br.Value; item.rate = Convert.ToDecimal(br.Rate); item.kg_lb = routing.Unit; item.agent_no = rate_type == 1 ? routing.agent_org_account_number : 0; item.customer_no = rate_type == 4 ? routing.customer_org_account_number : 0; item.carrier = Convert.ToInt32(rate.CarrierCode); item.elt_account_number = elt_account_number; item.origin_port = routing.Origin; item.dest_port = routing.Dest; item.share = Convert.ToDecimal(rate.Share); list.Add(item); item_no++; } } } } RateManagementDA DA = new RateManagementDA(); try { DA.SaveRate(elt_account_number, customer_org_num, rate_type, list); } catch (Exception ex) { throw ex; } ClearRateRoutings(); return(GetRateRoutings(elt_account_number, customer_org_num, rate_type)); }