public IHttpActionResult PutRateTable(int id, RateTable rateTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != rateTable.Id) { return(BadRequest()); } db.Entry(rateTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!RateTableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
protected void Page_Load(object sender, EventArgs e) { this.GridView1.AllowPaging = true; this.GridView1.PageSize = 5; this.GridView1.PagerSettings.Mode = PagerButtons.NextPrevious; this.GridView1.DataSource = RateTable.GetTopRated(5); GridView1.DataBind(); }
private void PersistModelForAgentBuyingRate(RateTable model) { RateManagementBL bl = new RateManagementBL(); List <RateRouting> routes = bl.GetRateRoutings(int.Parse(GetCurrentELTUser().elt_account_number), model.AgentAccount, Convert.ToInt32(RateType.AgentBuyingRate)); foreach (var view_route in model.RateRoutes) { RateRouting routing = new RateRouting(); int count = (from c in routes where c.ID == view_route.RouteID select c).Count(); if (count > 0) { routing = (from c in routes where c.ID == view_route.RouteID select c).Single(); } else { routes.Add(routing); } foreach (var view_row in view_route.Rows) { var rate = (from c in routing.Rates where c.RateID == view_row.Id select c).Single(); routing.agent_org_account_number = int.Parse(view_route.HeaderRow.RateHeaderColumns[0].Value); routing.AgentOrgName = view_route.HeaderRow.RateHeaderColumns[0].Text; routing.Origin = view_route.HeaderRow.RateHeaderColumns[1].Text; routing.Dest = view_route.HeaderRow.RateHeaderColumns[2].Text; routing.Unit = view_route.HeaderRow.RateHeaderColumns[3].Value; for (int i = 0; i < view_row.Columns.Count; i++) { if (view_row.Columns[i].WeightBreakValueTag == "CarrierCode") { rate.CarrierCode = view_row.Columns[i].Value; } if (view_row.Columns[i].WeightBreakValueTag == "Share") { rate.Share = view_row.Columns[i].Text; } if (i >= AppConstants.AgentBuyingRateDataColumnStartIndex) { for (int k = 0; k < rate.RateDefinitionColums.Count; k++) { if (view_row.Columns[i].WeightBreakValueTag == rate.RateDefinitionColums[k].Value) { rate.RateDefinitionColums[k].Rate = view_row.Columns[i].Text; } } } } } } bl.PesisteRateRouting(routes); }
public IHttpActionResult GetRateTable(int id) { RateTable rateTable = db.RateTables.Find(id); if (rateTable == null) { return(NotFound()); } return(Ok(rateTable)); }
public IHttpActionResult PostRateTable(RateTable rateTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.RateTables.Add(rateTable); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = rateTable.Id }, rateTable)); }
private void rateProduct(int rate) { String UserN = Session["UserN"].ToString(); int prodId = int.Parse(Label10.Text); if (RateTable.Exist(UserN, prodId)) { RateTable.Update(UserN, prodId, rate); } else { RateTable.Insert(UserN, prodId, rate); } }
public IHttpActionResult DeleteRateTable(int id) { RateTable rateTable = db.RateTables.Find(id); if (rateTable == null) { return(NotFound()); } db.RateTables.Remove(rateTable); db.SaveChanges(); return(Ok(rateTable)); }
private void PersistViewModel(RateTable model) { if (model.RateType == RateType.CustomerSellingRate) { PersistModelForCustomerSellingRate(model); } else if (model.RateType == RateType.AirLineBuyingRate) { PersistModelForAirlineBuyingRate(model); } else if (model.RateType == RateType.AgentBuyingRate) { PersistModelForAgentBuyingRate(model); } else if (model.RateType == RateType.IATARate) { PersistModelForIATARate(model); } }
public PatientsDataSet() { DT_PatientList = new List <PatientListTable>(); DT_Rates = new RateTable(); }
static public void provide_rate(RateTable current_rates) { rate_table = current_rates; }
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; } } } } } }
public ActionResult RateTable(RateTable model) { RateManagementBL bl = new RateManagementBL(); if (!string.IsNullOrEmpty(Request["ActionParam"])) { if (Convert.ToString(Request["ActionParam"]) == "SaveAll") { List <RateRouting> rRList = null; PersistViewModel(model); rRList = bl.GetRateRoutingFromSession((int)model.RateType); bool isValid = true; //모든 타입에 저장시 보아야할 것은 중복된 carrier code 이다. foreach (var r in rRList) { foreach (var rate in r.Rates) { var count = from c in r.Rates where c.CarrierCode == rate.CarrierCode select c; if (count.Count() > 1) { MsgText = "Duplicate Carrier Code exists. Save failed!"; isValid = false; break; } } if (!isValid) { break; } } if (isValid) { MsgText = "Rate table saved successfully!"; try { bl.SaveRateInfo(rRList); } catch (Exception ex) { MsgText = ex.Message; } } } if (Convert.ToString(Request["ActionParam"]) == "CancelAddRoute") { model.ClientAction = "CancelAddRoute"; } if (Convert.ToString(Request["ActionParam"]) == "SaveRoute") { var HeaderRow = model.RateRoutes[0].HeaderRow; SetMissingDropDownTextForRateHeaderRow(HeaderRow); RateRouting routing = new RateRouting(); try { GetNewRouteInfoFromView(model, routing); bl.InsertRoute(routing); } catch (Exception ex) { model.ShouldOpenAddRoute = true; MsgText = ex.Message; } } if (Convert.ToString(Request["ActionParam"]) == "AddRoute") { PersistViewModel(model); int newRateId = bl.GetNewRoutingID(); RateRoute RateRoute = new RateRoute(model.RateType) { RouteID = newRateId, Mode = RateRouteMode.Add }; model.RateRoutes.Clear(); model.RateRoutes.Add(RateRoute); model.ClientAction = "AddRoute"; return(View(model)); } if (Convert.ToString(Request["ActionParam"]) == "AddCarrier") { PersistViewModel(model); int AddCarrierRouteID = model.AddCarrierRouteID; RateRoute target = (from c in model.RateRoutes where c.RouteID == AddCarrierRouteID select c).Single(); var routing = bl.GetRouting(target.RouteID); var emptyRate = GenerateEmptyRateAndCreateHeaderText(routing, target.HeaderRow); routing.Rates.Add(emptyRate); } if (Convert.ToString(Request["ActionParam"]) == "DeleteCarrier") { PersistViewModel(model); int DeleteCarrierRouteID = model.DeleteCarrierRouteID; int DeleteCarrierID = model.DeleteCarrierID; RateRoute target_route = (from c in model.RateRoutes where c.RouteID == DeleteCarrierRouteID select c).Single(); RateRow target_row = (from c in target_route.Rows where c.Id == DeleteCarrierID select c).Single(); var routing = bl.GetRouting(target_route.RouteID); if (routing.Rates.Count == 1) { bl.DeleteRoute(routing); } else { var rate = (from c in routing.Rates where c.RateID == DeleteCarrierID select c).Single(); bl.DeleteRate(DeleteCarrierID, DeleteCarrierRouteID); } } } SetVariablesToSession(model); if (model.IsInit == "Init") { model.IsInit = ""; bl.ClearRateRoutings(); } if (model.RateType == RateType.CustomerSellingRate) { GetCustomerSellingRate(model); } if (model.RateType == RateType.AgentBuyingRate) { GetAgentBuyingRate(model); } if (model.RateType == RateType.IATARate) { GetIATARate(model); } if (model.RateType == RateType.AirLineBuyingRate) { GetAirlineBuyingRate(model); } model.Message = MsgText; return(View(model)); }
private void GetNewRouteInfoFromView(RateTable model, RateRouting routing) { RateManagementBL bl = new RateManagementBL(); var rRList = bl.GetRateRoutingFromSession((int)model.RateType); RateHeaderRow HeaderRow = model.RateRoutes[0].HeaderRow; try { if (model.RateType == RateType.CustomerSellingRate) { //Check if 같은 customer , 같은 destination 그리고 같은 orgin 그리고 같은 Unit 이 있는지 보라. routing.customer_org_account_number = int.Parse(HeaderRow.RateHeaderColumns[0].Value); routing.CustomerOrgName = HeaderRow.RateHeaderColumns[0].Text; routing.Origin = HeaderRow.RateHeaderColumns[1].Value; routing.Dest = HeaderRow.RateHeaderColumns[2].Value; routing.elt_account_number = int.Parse(GetCurrentELTUser().elt_account_number); routing.Unit = HeaderRow.RateHeaderColumns[3].Value; routing.UnitText = HeaderRow.RateHeaderColumns[3].Text; if (routing.Origin == routing.Dest) { throw new Exception("Destination cannot be the same as the Origination!"); } var exists = from c in rRList where c.Dest == routing.Dest && c.Origin == routing.Dest && c.Unit == routing.Unit && c.customer_org_account_number == routing.customer_org_account_number select c; if (exists.Count() > 0) { throw new Exception("Same route exists!"); } Rate emptyRate = GenerateEmptyRateAndCreateHeaderText(routing, HeaderRow); routing.Rates.Add(emptyRate); } if (model.RateType == RateType.AgentBuyingRate) { //Check if 같은 agent, 같은 destination 그리고 같은 orgin 그리고 같은 Unit 이 있는지 보라. routing.agent_org_account_number = int.Parse(HeaderRow.RateHeaderColumns[0].Value); routing.AgentOrgName = HeaderRow.RateHeaderColumns[0].Text; routing.Origin = HeaderRow.RateHeaderColumns[1].Value; routing.Dest = HeaderRow.RateHeaderColumns[2].Value; routing.elt_account_number = int.Parse(GetCurrentELTUser().elt_account_number); routing.Unit = HeaderRow.RateHeaderColumns[3].Value; routing.UnitText = HeaderRow.RateHeaderColumns[3].Text; var exists = from c in rRList where c.Dest == routing.Dest && c.Origin == routing.Dest && c.Unit == routing.Unit && c.agent_org_account_number == routing.agent_org_account_number select c; if (exists.Count() > 0) { throw new Exception("Same route exists!"); } if (routing.Origin == routing.Dest) { throw new Exception("Destination cannot be the same as the Origination!"); } Rate emptyRate = GenerateEmptyRateAndCreateHeaderText(routing, HeaderRow); routing.Rates.Add(emptyRate); } if (model.RateType == RateType.AirLineBuyingRate) { //Check if 같은 destination 그리고 같은 orgin 그리고 같은 Unit 이 있는지 보라. routing.Origin = HeaderRow.RateHeaderColumns[0].Value; routing.Dest = HeaderRow.RateHeaderColumns[1].Value; routing.elt_account_number = int.Parse(GetCurrentELTUser().elt_account_number); routing.Unit = HeaderRow.RateHeaderColumns[2].Value; routing.UnitText = HeaderRow.RateHeaderColumns[2].Text; var exists = from c in rRList where c.Dest == routing.Dest && c.Origin == routing.Dest && c.Unit == routing.Unit select c; if (exists.Count() > 0) { throw new Exception("Same route exists!"); } if (routing.Origin == routing.Dest) { throw new Exception("Destination cannot be the same as the Origination!"); } Rate emptyRate = GenerateEmptyRateAndCreateHeaderText(routing, HeaderRow); routing.Rates.Add(emptyRate); } if (model.RateType == RateType.IATARate) { //Check if 같은 destination 그리고 같은 orgin 그리고 같은 Unit 이 있는지 보라. routing.Origin = HeaderRow.RateHeaderColumns[0].Value; routing.Dest = HeaderRow.RateHeaderColumns[1].Value; routing.elt_account_number = int.Parse(GetCurrentELTUser().elt_account_number); routing.Unit = HeaderRow.RateHeaderColumns[2].Value; routing.UnitText = HeaderRow.RateHeaderColumns[2].Text; var exists = from c in rRList where c.Dest == routing.Dest && c.Origin == routing.Dest && c.Unit == routing.Unit select c; if (exists.Count() > 0) { throw new Exception("Same route exists!"); } if (routing.Origin == routing.Dest) { throw new Exception("Destination cannot be the same as the Origination!"); } Rate emptyRate = GenerateEmptyRateAndCreateHeaderText(routing, HeaderRow); routing.Rates.Add(emptyRate); } } catch (Exception ex) { throw ex; } }
private void SetVariablesToSession(RateTable model) { Session["rate_customer_org_num"] = model.CustomerAccount; Session["rate_rate_type"] = (int)model.RateType; Session["rate_elt_account_number"] = int.Parse(GetCurrentELTUser().elt_account_number); }