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;
}
