private void ExportSellingCommission() { // filtro DropDownList ddlCompany = this.Parent.FindControl("ddlCompany") as DropDownList; DropDownList ddlVendor = this.Parent.FindControl("ddlVendor") as DropDownList; TextBox txtDateFrom = this.Parent.FindControl("txtDateFrom") as TextBox; TextBox txtDateTo = this.Parent.FindControl("txtDateTo") as TextBox; RadioButtonList rblQuery = this.Parent.FindControl("rblQuery") as RadioButtonList; DAL.Filters.SellingCommissionFilter filter = new DAL.Filters.SellingCommissionFilter() { Export_Company = ddlCompany.SelectedItem.Text, Export_Vendor = ddlVendor.SelectedItem.Text, Export_DateFrom = txtDateFrom.Text, Export_DateTo = txtDateTo.Text, Export_Query = (rblQuery.SelectedItem != null) ? rblQuery.SelectedItem.Text : "No Liquidados", }; if (filter.Export_Query == "Vendedores Liquidados") { TextBox txtLiquidateDateFrom = this.Parent.FindControl("txtLiquidateDateFrom") as TextBox; TextBox txtLiquidateDateTo = this.Parent.FindControl("txtLiquidateDateTo") as TextBox; filter.Export_LiquidateDateRegisteredFrom = txtLiquidateDateFrom.Text; filter.Export_LiquidateDateRegisteredTo = txtLiquidateDateTo.Text; } // totales TextBox txtTP = this.Parent.FindControl("txtTP") as TextBox; TextBox txtAMLA = this.Parent.FindControl("txtAMLA") as TextBox; TextBox txtOPE = this.Parent.FindControl("txtOPE") as TextBox; TextBox txtGsExport = this.Parent.FindControl("txtGsExport") as TextBox; TextBox txtVendor = this.Parent.FindControl("txtVendor") as TextBox; // exporto la página using (SellingCommissionPDF page = BuildManager.CreateInstanceFromVirtualPath(this.PagePath, typeof(Page)) as SellingCommissionPDF) { page.AppRelativeVirtualPath = this.PagePath; page.Filter = filter; page.SellingCommissions = (this.Parent.Parent.Parent as ucSellingCommission).SellingCommissions; page.TotalTP = txtTP.Text; page.TotalAMLA = txtAMLA.Text; page.TotalOPE = txtOPE.Text; page.TotalGsExport = txtGsExport.Text; page.TotalVendor = txtVendor.Text; StringWriter sw = new StringWriter(); HttpContext.Current.Server.Execute(page, sw, true); byte[] pdf = PdfHelper.Convert(sw.ToString(), "Comisión Vendedor"); FileHelper.DownloadFile(string.Format("{0}_{1}.pdf", this.FileName, DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss")), pdf, this.Context); } }
private DAL.Filters.SellingCommissionFilter ReadFilter() { DAL.Filters.SellingCommissionFilter filter = new DAL.Filters.SellingCommissionFilter(); filter.IsLiquidate = this.rblQuery.SelectedValue == "true"; if (!string.IsNullOrEmpty(this.ddlCompany.SelectedValue)) filter.COMP_Id = int.Parse(this.ddlCompany.SelectedValue); if (!string.IsNullOrEmpty(this.ddlVendor.SelectedValue)) filter.VND_Id = int.Parse(this.ddlVendor.SelectedValue); if (!string.IsNullOrEmpty(this.txtDateFrom.Text.Trim()) && this.revDateFrom.IsValid) filter.ORDR_DateFrom = App_Code.Helpers.ControlsHelper.GetDateTimeValueFromTextBox(this.txtDateFrom); if (!string.IsNullOrEmpty(this.txtDateTo.Text.Trim()) && this.revDateTo.IsValid) filter.ORDR_DateTo = App_Code.Helpers.ControlsHelper.GetDateTimeValueFromTextBox(this.txtDateTo); if (!string.IsNullOrEmpty(this.txtLiquidateDateFrom.Text.Trim()) && this.revLiquidateDateFrom.IsValid) filter.ORDR_LiquidateDateRegisteredFrom = App_Code.Helpers.ControlsHelper.GetDateTimeValueFromTextBox(this.txtLiquidateDateFrom); if (!string.IsNullOrEmpty(this.txtLiquidateDateTo.Text.Trim()) && this.revLiquidateDateTo.IsValid) filter.ORDR_LiquidateDateRegisteredTo = App_Code.Helpers.ControlsHelper.GetDateTimeValueFromTextBox(this.txtLiquidateDateTo); filter.Export_Company = ddlCompany.SelectedItem.Text; filter.Export_Vendor = ddlVendor.SelectedItem.Text; filter.Export_DateFrom = txtDateFrom.Text; filter.Export_DateTo = txtDateTo.Text; filter.Export_Query = (rblQuery.SelectedItem != null) ? rblQuery.SelectedItem.Text : "No Liquidados"; return filter; }