protected void btnExportExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
int total = lblTotal.Text == "" ? 0 : lblTotal.Text.ToInt();
if (total > base.EXCEL_SIZE_Key)
{
UCModalError.ShowMessageError = SysMessage.ExcelSizeError;
UCModalError.ShowModalError();
UpdatePanelGv.Update();
}
else
{
ExportBiz export = new ExportBiz();
Dictionary <string, string> columns = new Dictionary <string, string>();
columns.Add("ลำดับ", "RUN_NO");
columns.Add("เลขที่ใบสั่งจ่ายกลุ่ม", "GROUP_REQUEST_NO");
columns.Add("วันครบกำหนดชำระ", "EXPIRATION_DATE");
columns.Add("จำนวนเงินในใบสั่งจ่ายกลุ่ม", "GROUP_AMOUNT");
List <HeaderExcel> header = new List <HeaderExcel>();
header.Add(new HeaderExcel
{
NameColumnsOne = "วันที่ต้องชำระเงิน(เริ่ม) ",
ValueColumnsOne = txtStartPaidSubDate.Text,
NameColumnsTwo = "วันที่ต้องชำระเงิน(สิ้นสุด) ",
ValueColumnsTwo = txtEndPaidSubDate.Text
});
header.Add(new HeaderExcel
{
NameColumnsOne = "วันที่สอบ ",
ValueColumnsOne = txtTestingDate.Text,
NameColumnsTwo = "รหัสรอบสอบ ",
ValueColumnsTwo = txtTestingNo.Text
});
header.Add(new HeaderExcel
{
NameColumnsOne = "รหัสสนามสอบ ",
ValueColumnsOne = txtExamPlaceCode.Text
});
var biz = new BLL.PaymentBiz();
var res = biz.GetApplicantNoPaymentHeadder(Convert.ToDateTime(txtStartPaidSubDate.Text),
Convert.ToDateTime(txtEndPaidSubDate.Text), txtTestingDate.Text, txtTestingNo.Text, txtExamPlaceCode.Text, 1, base.EXCEL_SIZE_Key, false);
export.CreateExcel(res.DataResponse.Tables[0], columns, header, base.UserProfile);
}
}
catch { }
}
private void BindDataInGridview(Boolean CountAgain)
{
var biz = new BLL.PaymentBiz();
string ErrMsg = "";
if (txtStartPaidSubDate.Text == "")
{
Set_textDate(1);
}
if (txtEndPaidSubDate.Text == "")
{
Set_textDate(2);
}
int resultPage;
int DayValue = lblDayValue.Text == "" ? 0 : lblDayValue.Text.ToInt();
if (Convert.ToDateTime(txtStartPaidSubDate.Text) > DateTime.Today.AddDays(-DayValue))
{
ErrMsg = ErrMsg + "<br />- วันที่หมดอายุใบสั่งจ่าย(เริ่ม) ต้องน้อยกว่าวันที่ปัจจุบัน " + DayValue + " วัน";
Set_textDate(1);
}
if (Convert.ToDateTime(txtEndPaidSubDate.Text) > DateTime.Today.AddDays(-DayValue))
{
ErrMsg = ErrMsg + "<br />- วันที่หมดอายุใบสั่งจ่าย(สิ้นสุด) ต้องน้อยกว่าวันที่ปัจจุบัน " + DayValue + " วัน";
Set_textDate(2);
}
if (ErrMsg != "")
{
UCModalError.ShowMessageError = ErrMsg;
UCModalError.ShowModalError();
}
else
{
if (!string.IsNullOrEmpty(txtStartPaidSubDate.Text) && !string.IsNullOrEmpty(txtEndPaidSubDate.Text))
{
int Rpage = (txtNumberGvSearch.Text.Trim() == "") ? 0 : txtNumberGvSearch.Text.Trim().ToInt();
resultPage = (Rpage == 0) ? 1 : txtNumberGvSearch.Text.Trim().ToInt();
if ((rowPerpage.Text.Trim() == null) || (rowPerpage.Text.Trim() == "") || (rowPerpage.Text.ToInt() <= 0))
{
rowPerpage.Text = PageSize.ToString();
}
else
{
PageSize = Convert.ToInt32(rowPerpage.Text);
}
string TestNoo = txtTestingNo.Text.Trim() != "" ? txtTestingNo.Text.Trim() : "%";
string PlaceC = txtExamPlaceCode.Text.Trim() != "" ? txtExamPlaceCode.Text.Trim() : "%";
if (CountAgain)
{
#region Page
var CountPage = biz.GetApplicantNoPaymentHeadder(Convert.ToDateTime(txtStartPaidSubDate.Text),
Convert.ToDateTime(txtEndPaidSubDate.Text), txtTestingDate.Text, TestNoo, PlaceC, resultPage, PageSize, true);
if (CountPage.DataResponse != null)
{
if (Convert.ToInt32(CountPage.DataResponse.Tables[0].Rows[0]["CCount"].ToString()) > 0)
{
Int32 totalROWs = Convert.ToInt32(CountPage.DataResponse.Tables[0].Rows[0]["CCount"].ToString());
VisibleGV(gvSearch, totalROWs, Convert.ToInt32(rowPerpage.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
}
}
else
{
VisibleGV(gvSearch, 0, Convert.ToInt32(rowPerpage.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
}
txtTotalPage.Text = "1";
}
}
#endregion Page
}
var res = biz.GetApplicantNoPaymentHeadder(Convert.ToDateTime(txtStartPaidSubDate.Text),
Convert.ToDateTime(txtEndPaidSubDate.Text), txtTestingDate.Text, TestNoo, PlaceC, resultPage, PageSize, false);
if (res.IsError)
{
var errorMsg = res.ErrorMsg;
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
gvSearch.DataSource = res.DataResponse;
gvSearch.DataBind();
if (gvSearch.Rows.Count > 0)
{
btnDelete.Visible = true;
CheckBox ch_all = (CheckBox)gvSearch.HeaderRow.FindControl("CheckAll");
ch_all.Visible = true;
}
else
{
btnDelete.Visible = false;
CheckBox ch_all = (CheckBox)gvSearch.HeaderRow.FindControl("CheckAll");
ch_all.Visible = false;
}
gvSearch.Visible = true;
gv2.Visible = false;
gvApplicantNoPay.Visible = false;
lblDetailCandidateNoPay.Visible = false;
detaiLL.Visible = false;
}
}
else
{
UCModalError.ShowMessageError = SysMessage.PleaseSelectDate;
UCModalError.ShowModalError();
}
}
}