protected void btnExportExcel_Click(object sender, EventArgs e)
{
try
{
if (!ValidInput())
{
AppUtil.ClientAlert(Page, "กรุณาเลือกวันที่กดรับเลขรับแจ้งเริ่มต้น และ วันที่กดรับเลขรับแจ้งสิ้นสุด");
return;
}
//DataSet resultDs; //Coment by Pom 04/07/2016 - Warning variable is never used
decimal teleTeam = -1, telesale = -1, insComId = -1;;
decimal.TryParse(cmbTelesalesTeam.SelectedValue, out teleTeam);
decimal.TryParse(cmbTelesales.SelectedValue, out telesale);
decimal.TryParse(cmbInsuranceCom.SelectedValue, out insComId);
int coverTypeId = -1;
int.TryParse(cmbCoverageType.SelectedValue, out coverTypeId);
var filename = Path.GetTempPath() + "\\tmpexcel_052_" + Page.User.Identity.Name + ".xls";// Path.GetTempFileName();
var bz = new SlmScr052Biz();
if (bz.CreateExcel2(tdStartDate.DateValue, tdEndDate.DateValue, tdIncentiveStartDate.DateValue, tdIncentiveEndDate.DateValue, tdProtectStartDate.DateValue, tdProtectEndDate.DateValue, teleTeam, cmbTelesales.SelectedValue, insComId, coverTypeId, txtCustomerName.Text, txtCustomerLastName.Text, txtContractNo.Text, filename))
{
ExportExcel(filename, "สรุปข้อมูลการชำระ_" + DateTime.Now.ToString("yyyyMMdd_HHmm") + ".xls");
}
else
{
AppUtil.ClientAlert(this, bz.ErrorMessage);
}
}
catch (Exception ex)
{
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
// _log.Debug(message);
AppUtil.ClientAlert(Page, message);
}
}
