protected void Page_Load(object sender, EventArgs e) { string idSale = Convert.ToString(System.Web.HttpContext.Current.Session["idSale"]); string query = "SELECT * FROM carlessor.compra where idcompra = @idcompra"; ConnectionSevice.DetailInformation(gridView: GridViewDetailSale, query, idSale); }
protected void sendDetail_Click(object sender, EventArgs e) { if (GridViewDetail.Rows.Count > 0) { Random rnd = new Random(); int idSale = rnd.Next(1000); for (int i = 0; i < GridViewDetail.Rows.Count; i++) { TextBox inputQuantityDays = (TextBox)GridViewDetail.Rows[i].FindControl("quantityDay"); TextBox inputQuantityCars = (TextBox)GridViewDetail.Rows[i].FindControl("quantityCar"); Label labelquantityCarsBd = (Label)GridViewDetail.Rows[i].FindControl("stock"); Label labeltaxByCarsBd = (Label)GridViewDetail.Rows[i].FindControl("tarifadia"); sex = radioTypeSex.SelectedValue; coverageInfo_SelectedIndexChanged(sender, e); int quantityDays = !string.IsNullOrEmpty(inputQuantityDays.Text) ? Convert.ToInt32(inputQuantityDays.Text):0; int quantityCars = !string.IsNullOrEmpty(inputQuantityCars.Text) ? Convert.ToInt32(inputQuantityCars.Text) : 0; int quantityCarsBd = !string.IsNullOrEmpty(labelquantityCarsBd.Text) ? Convert.ToInt32(labelquantityCarsBd.Text) : 0; double taxByCar = !string.IsNullOrEmpty(labeltaxByCarsBd.Text) ? Convert.ToDouble(labeltaxByCarsBd.Text) : 0; Pricing pricingInfo = CalculateBySex(sex, quantityDays, quantityCars, taxByCar, coverage); if (quantityDays > 0 && quantityCars > 0 && quantityCarsBd > 0) { Label inputIdCar = (Label)GridViewDetail.Rows[i].FindControl("idautos"); int idCar = !string.IsNullOrEmpty(inputIdCar.Text) ? Convert.ToInt32(inputIdCar.Text) : 0; if (quantityCars <= quantityCarsBd) { int stockFinal = quantityCarsBd - quantityCars; ConnectionSevice.updateDetail(idCar, inputQuantityDays.Text, inputQuantityCars.Text, stockFinal, pricingInfo.amount, pricingInfo.discount, pricingInfo.totalAmount); ConnectionSevice.insertSale(idCar, idSale); totalAmount = totalAmount + pricingInfo.totalAmount; amount = amount + pricingInfo.amount; discount = discount + pricingInfo.discount; } else { BindDataList(); coverageInfo.ClearSelection(); radioTypeSex.ClearSelection(); Response.Write("<script>alert('Cantidad de autos ingresa es mayor a nuestro stock, Favor verifique') </script>"); } } } if (ConnectionSevice.insertSaleDetail(idSale, sex, coverage, amount, discount, totalAmount)) { HttpContext.Current.Session["idSale"] = idSale; Response.Redirect("~/DetailSale.aspx"); } } }
protected void signIn_Click(object sender, EventArgs e) { if (ConnectionSevice.SignIn(inputUser.Text, inputPassword.Text)) { Response.Redirect("~/DetailedInformation.aspx"); } else { inputUser.Text = null; inputPassword.Text = null; Response.Write("<script>alert('Usuario o contrasena erronea, Favor verifique') </script>"); } }
private Pricing CalculateBySex(string sex, int quantityDays, int quantityCars, double taxByCar, string coverage) { Pricing pricing = new Pricing(); double coverageTax = ConnectionSevice.getCoverageById(coverage); pricing.amount = quantityDays * coverageTax * quantityCars * taxByCar; switch (sex) { case "M": pricing.discount = quantityDays >= 5 ? pricing.amount * 0.20 : pricing.amount * 0.05; break; case "F": pricing.discount = quantityDays >= 5 ? pricing.amount * 0.15 : pricing.amount * 0.10; break; default: Console.WriteLine("No llego el dato sexo"); break; } pricing.totalAmount = pricing.amount - pricing.discount; return(pricing); }
private void BindDropDownList() { string query = "select * from carlessor.cobertura"; ConnectionSevice.DropDownListInfo(dropDownList: coverageInfo, query); }
//Private Methods private void BindDataList() { string query = "select * from carlessor.autos"; ConnectionSevice.DetailInformation(gridView: GridViewDetail, query); }