protected void Page_Load(object sender, EventArgs e)
{
((MasterPage.SaleLead) this.Master).ShowReportMenu();
((Label)Page.Master.FindControl("lblTopic")).Text = "สรุปข้อมูลการชำระ";
if (!IsPostBack)
{
cmbTelesalesTeam.DataSource = SlmScr052Biz.GetTeamTelesaleList();
cmbTelesalesTeam.DataBind();
cmbTelesalesTeam.Items.Insert(0, new ListItem("ทั้งหมด", "-1"));
cmbInsuranceCom.DataSource = SlmScr052Biz.GetInsuranceComList();
cmbInsuranceCom.DataBind();
cmbInsuranceCom.Items.Insert(0, new ListItem("ทั้งหมด", "-1"));
cmbCoverageType.DataSource = SlmScr052Biz.GetCoverageTypeList();
cmbCoverageType.DataBind();
cmbCoverageType.Items.Insert(0, new ListItem("ทั้งหมด", "-1"));
}
}
protected void PageSearchChange(object sender, EventArgs e)
{
try
{
if (!ValidInput())
{
AppUtil.ClientAlert(Page, "กรุณาเลือกวันที่กดรับเลขรับแจ้งเริ่มต้น และ วันที่กดรับเลขรับแจ้งสิ้นสุด");
return;
}
//DataSet resultDs;
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 resultList = SlmScr052Biz.GetSearchResult(tdStartDate.DateValue, tdEndDate.DateValue, tdIncentiveStartDate.DateValue, tdIncentiveEndDate.DateValue, tdProtectStartDate.DateValue, tdProtectEndDate.DateValue, teleTeam, cmbTelesales.SelectedValue, insComId, coverTypeId, txtCustomerName.Text, txtCustomerLastName.Text, txtContractNo.Text , out resultDs);
SlmScr052Biz bz = new SlmScr052Biz();
var resultList = bz.GetSearchResult2(tdStartDate.DateValue, tdEndDate.DateValue, tdIncentiveStartDate.DateValue, tdIncentiveEndDate.DateValue, tdProtectStartDate.DateValue, tdProtectEndDate.DateValue, teleTeam, cmbTelesales.SelectedValue, insComId, coverTypeId, txtCustomerName.Text, txtCustomerLastName.Text, txtContractNo.Text);
if (sender == null)
{
BindGridview(pcTop, gvResult, resultList.ToArray(), 1);
}
else
{
BindGridview(pcTop, gvResult, resultList.ToArray(), pcTop.SelectedPageIndex);
}
}
catch (Exception ex)
{
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
// _log.Debug(message);
AppUtil.ClientAlert(Page, message);
}
upResult.Update();
}
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);
}
}
