protected void btnGenReceiptAll_Click(object sender, EventArgs e)
{
if (lsGenRecive.Count == 0)
{
this.MasterSite.ModelError.ShowMessageError = SysMessage.ChooseData;
this.MasterSite.ModelError.ShowModalError();
}
else
{
BLL.PaymentBiz biz = new BLL.PaymentBiz();
DTO.ResponseMessage <bool> res = biz.GenReceiptAll(lsGenRecive.ToArray());
if (res.ResultMessage == false)
{
this.MasterSite.ModelError.ShowMessageError = res.ErrorMsg;
this.MasterSite.ModelError.ShowModalError();
}
else
{
this.MasterSite.ModelSuccess.ShowMessageSuccess = Resources.infoGenPayment_001;
this.MasterSite.ModelSuccess.ShowModalSuccess();
lsGenRecive.Clear();
}
BindDataInGridView();
this.UpdatePanelSearch.Update();
}
}
protected void btnGenLicense_Click(object sender, EventArgs e)
{
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
sw.Start();
var biz = new BLL.PaymentBiz();
if (ListLicense.Count == 0)
{
this.MasterSite.ModelError.ShowMessageError = "กรุณาเลือกรายการ";
this.MasterSite.ModelError.ShowModalError();
return;
}
var res = biz.Insert12T(this.ListLicense.ToArray());
if (res.ResultMessage == false)
{
this.MasterSite.ModelError.ShowMessageError = "ให้ความเห็นชอบออกใบอนุญาตไม่สำเร็จ";
this.MasterSite.ModelError.ShowModalError();
}
else
{
ListLicense = new List <DTO.GenLicense>();
this.MasterSite.ModelSuccess.ShowMessageSuccess = Resources.infoLicenseApprove_001;
this.MasterSite.ModelSuccess.ShowModalSuccess();
BindDataInGridView();
}
sw.Stop();
TimeSpan sp3 = sw.Elapsed;
TimeSpan duration3 = sp3.Duration();
}
protected void btnImport_Click(object sender, EventArgs e)
{
BLL.PaymentBiz biz = new BLL.PaymentBiz();
IList <DTO.ImportBankTransferData> refRequests = new List <DTO.ImportBankTransferData>();
foreach (var item in GvCheckListSource)
{
refRequests.Add(new DTO.ImportBankTransferData()
{
Id = item.Id, Ref1 = item.Ref1, Status = item.Status, ChangeRef1 = item.ChangeRef1, ChangeAmount = item.ChangeAmount
});
}
DTO.ImportBankTransferRequest importBankTransferRequest = new DTO.ImportBankTransferRequest();
importBankTransferRequest.ImportBankTransfers = refRequests;
importBankTransferRequest.UserOicId = UserProfile.OIC_EMP_NO;
//importBankTransferRequest.UserOicId = UserProfile.OIC_User_Id;
importBankTransferRequest.GroupId = hdfGroupID.Value;
importBankTransferRequest.UserId = UserProfile.Id;
var res = biz.SubmitBankTrans(importBankTransferRequest);
if (res.IsError)
{
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
hdfID.Value = string.Empty;
hdfGroupID.Value = string.Empty;
pnlImportFile.Visible = false;
UCModalSuccess.ShowMessageSuccess = res.DataResponse;
UCModalSuccess.ShowModalSuccess();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string pettition = Request.QueryString["pettition"].Trim();
string id_card = Request.QueryString["IDCard"].Trim();
string txtfirsname = Request.QueryString["FirstName"].Trim();
string txtlastname = Request.QueryString["LastName"].Trim();
var biz = new BLL.PaymentBiz();
//var res = biz.GetReportNumberPrintBill(txtIDCard.Text, ddlLicenseType.SelectedValue, txtFirstName.Text, txtLastName.Text, resultPage, PageSize, false);
//var res = biz.GetReportNumberPrintBill(id_card, pettition, txtfirsname, txtlastname, 1, 1, false);
var res = biz.GetDownloadReceiptHistory(id_card, pettition, txtfirsname, txtlastname);
DataTable dt = (res.DataResponse != null && res.DataResponse.Tables[0].Rows.Count > 0) ? res.DataResponse.Tables[0] : null;
if (dt != null)
{
report.Load((Server.MapPath("../Reports/RptHistory.rpt")));
report.SetDataSource(res.DataResponse.Tables[0]);
report.SetParameterValue("datethai", DateTime.Now.ToShortDateString());
CRYreport.ReportSource = report;
}
else
{
Response.Write("ไม่พบข้อมูล");
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void btnExportExcel_Click(object sender, ImageClickEventArgs e)
{
int total = lblTotal.Text == "" ? 0 : lblTotal.Text.ToInt();
if (total > base.EXCEL_SIZE_Key)
{
UCModalError1.ShowMessageError = SysMessage.ExcelSizeError;
UCModalError1.ShowModalError();
UpdatePanelSearch.Update();
}
else
{
try
{
Dictionary <string, string> columns = new Dictionary <string, string>();
columns.Add("ลำดับที่", "RUN_NO");
columns.Add("ประเภทใบเสร็จ", "PETITION_TYPE_NAME");
columns.Add("เลขที่ใบเสร็จ", "RECEIPT_NO");
columns.Add("ชื่อ-นามสกุล", "FLNAME");
columns.Add("เลขบัตรประชาชน", "ID_CARD_NO");
columns.Add("วันที่สั่งจ่าย", "PAYMENT_DATE");
columns.Add("วันที่ชำระเงิน", "ORDER_DATE");
columns.Add("เลขที่ใบอนุญาต", "LICENSE_NO");
columns.Add("จำนวนเงิน", "AMOUNT");
columns.Add("จำนวนครั้งที่พิมพ์", "PRINT_TIMES");
ExportBiz export = new ExportBiz();
var biz = new BLL.PaymentBiz();
var res = biz.GetReportNumberPrintBill(txtIDCard.Text, ddlLicenseType.SelectedValue, txtFirstName.Text, txtLastName.Text, 1, base.EXCEL_SIZE_Key, false);
export.CreateExcel(res.DataResponse, columns);
}
catch { }
}
}
private void InitData()
{
try
{
string IDCard = Request.QueryString["IDCard"].Trim();
string LicenseType = Request.QueryString["LicenseType"].Trim();
string FirstName = Request.QueryString["FirstName"].Trim();
string LastName = Request.QueryString["LastName"].Trim();
string Click = Request.QueryString["Click"];
BLL.PaymentBiz biz = new BLL.PaymentBiz();
var res = biz.GetReportNumberPrintBill(IDCard, LicenseType, FirstName, LastName, 0, 0, false);
DataTable dt = res.DataResponse.Tables.Count > 0 ? res.DataResponse.Tables[0] : null;
string ReportFolder = base.ReportFilePath_Key;
if (Click == "Print")
{
//if ((base.UserProfile.MemberType == DTO.RegistrationType.OIC.GetEnumValue()) ||
// (base.UserProfile.MemberType == DTO.RegistrationType.OICFinace.GetEnumValue()))
if (base.UserProfile.MemberType == DTO.RegistrationType.OIC.GetEnumValue()) //แก้ตามเอกสารของ SA
{
rpt.Load(Server.MapPath(ReportFolder + "RptElectronicReceipt.rpt"));
rpt.DataDefinition.FormulaFields["UserName"].Text = "'" + base.UserProfile.Name + "'";
rpt.SetDataSource(dt);
rpt.SetParameterValue("datethai", DateTime.Now.ToShortDateString());
BindReport(rpt);
//downloadexcel(rpt);
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
//this.ListPayment.Clear();
clearControl();
if (gvPaymentAssimilate.Visible == true)
{
//foreach (GridViewRow gr in gvPaymentAssimilate.Rows)
//{
// if (((CheckBox)gr.FindControl("chkSelectPayment")).Checked == true)
// {
// var lblPaymentAssimilateGv = (Label)gr.FindControl("lblPaymentAssimilateGv");
// this.ListPayment.Add(lblPaymentAssimilateGv.Text);
// }
//}
if (lsOderInvoice.Count > 0)
{
var biz = new BLL.PaymentBiz();
//lblPaymentAssimilateNumberDetail.Text = res.DataResponse.Ref1;
//lblRef2.Text = res.DataResponse.Ref2;
mpEdit.Show();
//UplPopUp.Update();
}
else
{
//AlertMessage.ShowAlertMessage(string.Empty, SysMessage.ChooseData);
this.MasterSite.ModelError.ShowMessageError = SysMessage.ChooseData;
this.MasterSite.ModelError.ShowModalError();
}
}
}
protected void exportExcel2_Click(object sender, ImageClickEventArgs e)
{
ExportBiz export = new ExportBiz();
try
{
int total = lblRec.Text == "" ? 0 : lblRec.Text.ToInt();
if (total > base.EXCEL_SIZE_Key)
{
UCModalError.ShowMessageError = SysMessage.ExcelSizeError;
UCModalError.ShowModalError();
UpdatePanelGv.Update();
}
else
{
Dictionary <string, string> columns = new Dictionary <string, string>();
columns.Add("ลำดับ", "RUN_NO");
columns.Add("เลขบัตรประชาชน", "ID_CARD_NO");
columns.Add("วันที่สมัคร", "CREATED_DATE");
columns.Add("ชื่อ", "FIRSTNAME");
columns.Add("นามสกุล", "LASTNAME");
columns.Add("วันที่สอบ", "TESTING_DATE");
var biz = new BLL.PaymentBiz();
var res = biz.GetApplicantNoPayment(txtTestingDate.Text, txtTestingNo.Text, txtExamPlaceCode.Text, Convert.ToDateTime(txtStartPaidSubDate.Text),
Convert.ToDateTime(txtEndPaidSubDate.Text), H_NOW_REQUEST.Value, 1, base.EXCEL_SIZE_Key, false);
int[] colum = new int[] { 9 };
export.CreateExcel(res.DataResponse, columns);
}
}
catch { }
}
protected void hplView_Click(object sender, EventArgs e)
{
var gr = (GridViewRow)((LinkButton)sender).NamingContainer;
var HeadNo = (Label)gr.FindControl("lblHeadNoGv");
var PaymentNo = (Label)gr.FindControl("lblPaymentNoGv");
MPDetail.Show();
lblpaymentNo.Text = HeadNo.Text;
var biz = new BLL.PaymentBiz();
var res = biz.GetRecriptByHeadRequestNoAndPaymentNo(HeadNo.Text, PaymentNo.Text);
if (res == null)
{
var errorMsg = res.ErrorMsg;
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
GVPopupReceipt.DataSource = res.DataResponse;
GVPopupReceipt.DataBind();
UpdatePanelSearch.Update();
}
}
protected void btnDownload_Click(object sender, EventArgs e)
{
var gr = (GridViewRow)((LinkButton)sender).NamingContainer;
Label lblPaymentNoGv = (Label)gr.FindControl("lblPaymentNoGv");
Label lblHeadNoGv = (Label)gr.FindControl("lblHeadNoGv");
Label lblOrderGv = (Label)gr.FindControl("lblOrderPayGv");
Label lblPathFile = (Label)gr.FindControl("lblPathFile");
var data2 = new List <DTO.SubPaymentDetail>();
data2.Add(new DTO.SubPaymentDetail
{
HEAD_REQUEST_NO = lblHeadNoGv.Text,
PAYMENT_NO = lblPaymentNoGv.Text,
Click = "Download"
});
var biz = new BLL.PaymentBiz();
var resDownload = biz.PrintDownloadCount(data2.ToArray(), "", base.UserId);
string SumPath = lblPathFile.Text + "-D";
Session["FileName"] = SumPath;
ToolkitScriptManager.RegisterStartupScript(this, this.GetType(), "เอกสาร",
"window.open('../UserControl/SavePdfFileFromStream.aspx');", true);
UpdatePanelSearch.Update();
}
protected void getPlace(string type)
{
string id = ddlGroupExam.SelectedValue.ToString();
string SQLtemp = string.Empty;
switch (type)
{
case "A":
var biz = new BLL.DataCenterBiz();
var res = biz.GetExamPlace_UnderAssocicate("", id);
if (res.IsError)
{
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
bludDiv.Visible = false;
DataSet ds = res.DataResponse;
DataTable dt = ds.Tables[0];
ddlExamPlaceCode.DataTextField = "name";
ddlExamPlaceCode.DataValueField = "Id";
ddlExamPlaceCode.DataSource = dt.DataSet;
ddlExamPlaceCode.DataBind();
ddlExamPlaceCode.Items.Insert(0, SysMessage.DefaultSelecting);
ddlExamPlaceCode.SelectedIndex = 0;
}
break;
case "G":
var bizz = new BLL.PaymentBiz();
var ress = bizz.GetExamCode(id);
if (ress.IsError)
{
UCModalError.ShowMessageError = ress.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
DataSet dss = ress.DataResponse;
DataTable dtt = dss.Tables[0];
ddlExamPlaceCode.DataTextField = "PLACE_NAME";
ddlExamPlaceCode.DataValueField = "PLACE_ID";
ddlExamPlaceCode.DataSource = dtt.DataSet;
ddlExamPlaceCode.DataBind();
ddlExamPlaceCode.Items.Insert(0, SysMessage.DefaultSelecting);
ddlExamPlaceCode.SelectedIndex = 0;
}
break;
default:
break;
}
}
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 { }
}
protected void BindPage()
{
PAGE_SIZE = Convert.ToInt32(txtInputMaxrow.Text);
var biz = new BLL.PaymentBiz();
var resultPage = txtNumberGvSearch.Text.ToInt();
var res1 = biz.GenPaymentNumberTable(base.UserProfile.IdCard,
Convert.ToDateTime(txtStartPaidSubDate.Text),
Convert.ToDateTime(txtEndPaidSubDate.Text), txtPaidGroup.Text.Replace(" ", ""), "N", resultPage, PAGE_SIZE);
gvSearch.DataSource = res1.DataResponse;
gvSearch.DataBind();
}
protected void BindPage()
{
PAGE_SIZE = Convert.ToInt32(txtInputMaxrow.Text);
var biz = new BLL.PaymentBiz();
var resultPage = txtNumberGvSearch.Text.ToInt();
var res = biz.GetPaymentLicenseAppove(ddlTypePay.SelectedValue.ToString(), txtIdCard.Text,
txtOrder.Text, Convert.ToDateTime(txtStartDate.Text)
, Convert.ToDateTime(txtEndDate.Text), txtFirstName.Text, txtLastName.Text, "N", resultPage, PAGE_SIZE);
gvSearch.Visible = true;
gvSearch.DataSource = res.DataResponse;
gvSearch.DataBind();
}
protected void btnExportExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
int total = lblTotal.Text == "" ? 0 : Regex.Replace(lblTotal.Text, "[^0-9]", "").ToInt();
if (total > base.EXCEL_SIZE_Key)
{
UCModalError.ShowMessageError = SysMessage.ExcelSizeError;
UCModalError.ShowModalError();
UpdatePanelSearch.Update();
}
else
{
ExportBiz export = new ExportBiz();
Dictionary <string, string> columns = new Dictionary <string, string>();
columns.Add("ลำดับ", "RUN_NO");
columns.Add("ประเภทการชำระ", "PETITION_TYPE_NAME");
columns.Add("บัตรประชาชน", "ID_CARD_NO");
columns.Add("ชื่อ", "FIRST_NAME");
columns.Add("นามสกุล", "LASTNAME");
columns.Add("เลขที่ใบสั่งจ่าย", "group_request_no");
columns.Add("รหัสรอบสอบ", "TESTING_NO");
columns.Add("วันที่ออกใบสั่งจ่าย", "CREATED_DATE");
columns.Add("วันที่ชำระเงิน", "payment_date");
columns.Add("เลขที่ใบเสร็จ", "RECEIPT_NO");
List <HeaderExcel> header = new List <HeaderExcel>();
header.Add(new HeaderExcel
{
NameColumnsOne = "หน่วยงานจัดสอบ ",
ValueColumnsOne = ddlGroupExam.SelectedItem.Text,
NameColumnsTwo = "สนามสอบ ",
ValueColumnsTwo = ddlExamPlaceCode.SelectedItem.Text
});
header.Add(new HeaderExcel
{
NameColumnsOne = "วันที่สั่งจ่าย(เริ่ม) ",
ValueColumnsOne = txtStartDate.Text,
NameColumnsTwo = "วันที่สั่งจ่าย(สิ้นสุด) ",
ValueColumnsTwo = txtEndDate.Text
});
var biz = new BLL.PaymentBiz();
var res = biz.GetPaymentDetailByGroup(base.UserProfile.MemberType, ddlGroupExam.SelectedValue.ToString(),
ddlExamPlaceCode.SelectedValue.ToString(), Convert.ToDateTime(txtStartDate.Text), Convert.ToDateTime(txtEndDate.Text), 1, base.EXCEL_SIZE_Key, false, base.UserProfile.CompCode);
export.CreateExcel(res.DataResponse.Tables[0], columns, header, base.UserProfile);
}
}
catch { }
}
private void GenPDFDownload1(string ReportFolder, string PDF_OIC, string FileNameInput, List <RptReciveClassService> ls, List <DTO.SubPaymentDetail> data)
{
var biz = new BLL.PaymentBiz();
var res = biz.PrintDownloadCount(data.ToArray(), "", base.UserId);
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath(ReportFolder + "RptRecive.rpt"));
rpt.SetDataSource(ls);
BindReport(rpt);
rpt.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath(PDF_OIC + FileNameInput));
}
protected void btn4_Click(object sender, EventArgs e)
{
var biz = new BLL.PaymentBiz();
DTO.UserProfile userProfile = new DTO.UserProfile
{
CompCode = "1008",
Id = "123",
IdCard = "456",
MemberType = 2,
};
//var res = biz.GetSubGroup("01", userProfile, 0, 10);
//gv.DataSource = res.DataResponse;
//gv.DataBind();
}
protected void btnPrint_Click(object sender, EventArgs e)
{
BLL.PaymentBiz biz = new BLL.PaymentBiz();
var res = biz.GetReportNumberPrintBill(txtIDCard.Text, ddlLicenseType.SelectedValue, txtFirstName.Text, txtLastName.Text, 0, 0, false);
DataTable dt = res.DataResponse.Tables.Count > 0 ? res.DataResponse.Tables[0] : null;
string ReportFolder = base.ReportFilePath_Key;
ReportDocument report = new ReportDocument();
report.Load(Server.MapPath(ReportFolder + "RptElectronicReceipt.rpt"));
report.DataDefinition.FormulaFields["UserName"].Text = "'" + base.UserProfile.Name + "'";
report.SetDataSource(dt);
report.SetParameterValue("datethai", DateTime.Now.ToShortDateString());
CRVStatic.ReportSource = report;
CRVStatic.DataBind();
}
private void GetTempBankTransDetail(string strGroupID, string strID)
{
BLL.PaymentBiz biz = new BLL.PaymentBiz();
var res = biz.GetTempBankTransDetail(strGroupID, strID);
if (res.IsError)
{
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
txtCompanyName.Text = res.DataResponse.COMPANY_NAME;
txtEffectiveDate.Text = PaymentHtmlHelper.ResolveDate(res.DataResponse.EFFECTIVE_DATE);
txtServiceCode.Text = res.DataResponse.SERVICE_CODE;
if (res.DataResponse.BankType == "H")
{
txtTotal.Text = PaymentHtmlHelper.PhaseKTBMoney(res.DataResponse.TOTAL_CREDIT_AMOUNT);
txtAmount.Text = PaymentHtmlHelper.PhaseKTBMoney(res.DataResponse.AMOUNT);
}
else if (res.DataResponse.BankType == "1")
{
txtTotal.Text = PaymentHtmlHelper.PhaseCityBankMoney(res.DataResponse.TOTAL_CREDIT_AMOUNT);
txtAmount.Text = PaymentHtmlHelper.PhaseCityBankMoney(res.DataResponse.AMOUNT);
}
txtBankCode.Text = res.DataResponse.BANK_CODE;
txtCompanyAccount.Text = res.DataResponse.COMPANY_ACCOUNT;
txtPaymentDate.Text = PaymentHtmlHelper.ResolveDate(res.DataResponse.PAYMENT_DATE);
txtPaymentTime.Text = res.DataResponse.PAYMENT_TIME;
txtCustomerName.Text = res.DataResponse.CUSTOMER_NAME;
txtCustomerNoRef1.Text = res.DataResponse.CUSTOMER_NO_REF1;
txtRef2.Text = res.DataResponse.REF2;
txtRef3.Text = res.DataResponse.REF3;
txtBranchNo.Text = res.DataResponse.BRANCH_NO;
txtTellerNo.Text = res.DataResponse.TELLER_NO;
txtKindOfTransaction.Text = res.DataResponse.KIND_OF_TRANSACTION;
txtTranSactionCode.Text = res.DataResponse.TRANSACTION_CODE;
txtChequeNo.Text = res.DataResponse.CHEQUE_NO;
txtChequeBankCode.Text = res.DataResponse.CHEQUE_BANK_CODE;
UpdatePanelSearch.Update();
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
try
{
BLL.PaymentBiz biz = new BLL.PaymentBiz();
IList <DTO.ImportBankTransferData> refRequests = new List <DTO.ImportBankTransferData>();
foreach (var item in GvPaymentMissingSource.Where(a => (a.ChangeRef1 != "" && !String.IsNullOrEmpty(a.ChangeRef1))))
{
refRequests.Add(new DTO.ImportBankTransferData()
{
Id = item.Id, Ref1 = item.Ref1, Status = item.Status, ChangeRef1 = item.ChangeRef1, ChangeAmount = item.ChangeAmount
});
}
DTO.ImportBankTransferRequest importBankTransferRequest = new DTO.ImportBankTransferRequest();
importBankTransferRequest.ImportBankTransfers = refRequests;
importBankTransferRequest.UserOicId = UserProfile.OIC_EMP_NO;
//importBankTransferRequest.UserOicId = UserProfile.OIC_User_Id;
var res = biz.ReSubmitBankTrans(importBankTransferRequest);
if (res.IsError)
{
((Site1)Master).ModelError.ShowMessageError = res.ErrorMsg;
((Site1)Master).ModelError.ShowModalError();
}
else
{
((Site1)Master).ModelSuccess.ShowMessageSuccess = res.DataResponse;
((Site1)Master).ModelSuccess.ShowModalSuccess();
ClearAndDisbleImport();
ClearGridViewAll();
txtPaymentDateStart.Text = "";
txtPaymentDateEnd.Text = "";
}
}
catch (Exception ex)
{
((Site1)Master).ModelError.ShowMessageError = "ไม่สามารถทำรายการได้.";
((Site1)Master).ModelError.ShowModalError();
LoggerFactory.CreateLog().LogError("ไม่สามารถทำรายการได้.", ex);
}
}
protected void btnFindPayment_OnClick(object sender, EventArgs e)
{
//DTO.BankTransaction bankTransaction = GvPaymentMissingSource.SingleOrDefault(a => a.Ref1 == txtFindPaymentSelected.Text);
var biz = new BLL.PaymentBiz();
gvFindPaymentResult.DataSource = null;
DTO.GetPaymentByRangeRequest request = new DTO.GetPaymentByRangeRequest();
request.PaymentStarting = txtPaymentNumberStart.Text.Trim();
request.PaymentEnding = txtPaymentNumberEnd.Text.Trim();
//request.Amount = bankTransaction.Amount;
var result = biz.GetPaymentByRange(request);
gvFindPaymentResult.DataSource = result.DataResponse.PaymentByRangeResults;
gvFindPaymentResult.DataBind();
ModFindPayment.Show();
}
protected void GetReceiptHis(string RcvID)
{
try
{
var biz = new BLL.PaymentBiz();
DTO.ResponseService <DataSet> res = biz.GetRcvHisDetail(RcvID, "L", "1", "100");
if (res.IsError)
{
AlertMessage.ShowAlertMessage(string.Empty, res.ErrorMsg);
}
else
{
lblCount.Text = "(ดาวน์โหลดทั้งหมด <u>" + Convert.ToString(res.DataResponse.Tables[0].Rows.Count) + "</u> ครั้ง)";
pop_FROM_gv.DataSource = res.DataResponse;
pop_FROM_gv.DataBind();
}
}
catch
{
}
}
protected void hplDelete_Click(object sender, EventArgs e)
{
var gr = (GridViewRow)((LinkButton)sender).NamingContainer;
var PaidGroup = (Label)gr.FindControl("lblGroupRequsetNo");
var biz = new BLL.PaymentBiz();
var res = biz.CancelGroupRequestNo(PaidGroup.Text);
if (res.IsError)
{
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
BindDataInGridView(true);
}
else
{
BindDataInGridView(true);
UCModalSuccess.ShowMessageSuccess = Resources.errorSysMessage_CreatePaymentSuccess;
UCModalSuccess.ShowModalSuccess();
}
UpdatePanelSearch.Update();
}
protected void btnSearchPayment_OnClick(object sender, EventArgs e)
{
Session["GvPaymentMissingSource"] = null;
PaymentNotCompleteRequest request = new PaymentNotCompleteRequest();
if (!String.IsNullOrWhiteSpace(txtFindRefNo.Text))
{
request.Ref1 = txtFindRefNo.Text.Trim();
}
if (!String.IsNullOrWhiteSpace(txtPaymentDateStart.Text))
{
request.StartDate = ParseDateFromString(txtPaymentDateStart.Text.Trim());
}
if (!String.IsNullOrWhiteSpace(txtPaymentDateEnd.Text))
{
request.EndDate = ParseDateFromString(txtPaymentDateEnd.Text.Trim());
}
BLL.PaymentBiz paymentBiz = new BLL.PaymentBiz();
DTO.ResponseService <DTO.PaymentNotCompleteResponse> res = paymentBiz.PaymentNotComplete(request);
if (res.IsError)
{
((Site1)Master).ModelError.ShowMessageError = res.ErrorMsg;
((Site1)Master).ModelError.ShowModalError();
pnlData.Visible = false;
}
else
{
Session["GvPaymentMissingSource"] = res.DataResponse.BankTransaction;
gvPaymentMissing.DataSource = GvPaymentMissingSource;
gvPaymentMissing.DataBind();
pnlData.Visible = true;
btnCancle.Visible = true;
btnCancle.Enabled = true;
//((Site1)Master).ModelSuccess.ShowModalSuccess();
}
}
//log4net
protected void StatusA_Click(object sender, EventArgs e)
{
GridViewRow gr = (GridViewRow)((LinkButton)sender).NamingContainer;
Label group_request = (Label)gr.FindControl("lblGroupRequsetNo");
Label lblReceiptNo = (Label)gr.FindControl("lblReceiptNo");
Label lblHEADREQUESTNO = (Label)gr.FindControl("lblHEADREQUESTNO");
Label lblPAYMENTNO = (Label)gr.FindControl("lblPAYMENTNO");
lsGenRecive.Add(new DTO.GenReceipt
{
RECEIPT_NO = lblReceiptNo.Text,
HEAD_REQUEST_NO = lblHEADREQUESTNO.Text,
PAYMENT_NO = lblPAYMENTNO.Text,
RECEIPT_BY_ID = base.UserProfile.Id,
});
if (lsGenRecive.Count == 0)
{
this.MasterSite.ModelError.ShowMessageError = SysMessage.ChooseData;
this.MasterSite.ModelError.ShowModalError();
}
else
{
BLL.PaymentBiz biz = new BLL.PaymentBiz();
DTO.ResponseMessage <bool> res = biz.GenReceiptAll(lsGenRecive.ToArray());
if (res.ResultMessage == false)
{
this.MasterSite.ModelError.ShowMessageError = res.ErrorMsg;
this.MasterSite.ModelError.ShowModalError();
}
else
{
this.MasterSite.ModelSuccess.ShowMessageSuccess = Resources.infoGenPayment_001;
this.MasterSite.ModelSuccess.ShowModalSuccess();
}
BindDataInGridView();
lsGenRecive.Clear();
this.UpdatePanelSearch.Update();
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (ListAppNoPay != null)
{
var biz = new BLL.PaymentBiz();
var res = biz.CancelApplicantsHeader(ListAppNoPay.ToArray());
if (res.IsError)
{
var errorMsg = res.ErrorMsg;
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
UCModalSuccess.ShowMessageSuccess = "ยกเลิกรายการ " + ListAppNoPay.Count + " รายการเรียบร้อยแล้ว";
UCModalSuccess.ShowModalSuccess();
btnDelete.Visible = true;
ClearData();
btnSearch_Click(sender, e);
// BindDataInGridview(true);
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
PnlDetail.Visible = true;
UpdatePanelGv.Update();
ListAppNoPay = new List <DTO.AppNoPay>();
if (gvSearch.Rows.Count == 0)
{
btnExportExcel.Visible = false;
}
}
}
else
{
UCModalError.ShowMessageError = Resources.errorApplicantNoPay_003;
UCModalError.ShowModalError();
}
}
protected void btnExportExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
int total = lblTotalrecord.Text == "" ? 0 : lblTotalrecord.Text.ToInt();
if (total > base.EXCEL_SIZE_Key)
{
this.MasterSite.ModelError.ShowMessageError = SysMessage.ExcelSizeError;
this.MasterSite.ModelError.ShowModalError();
UpdatePanelSearch.Update();
}
else
{
ExportBiz export = new ExportBiz();
var biz = new BLL.PaymentBiz();
string IdParameter;
if (base.UserProfile.MemberType == 1)
{
IdParameter = base.UserProfile.Id;
}
else
{
IdParameter = base.UserProfile.CompCode;
}
Dictionary <string, string> columns = new Dictionary <string, string>();
columns.Add("ลำดับ", "RUN_NO");
columns.Add("ใบสั่งจ่ายย่อย", "HEAD_REQUEST_NO");
columns.Add("ประเภทใบสั่งจ่าย", "PETITION_TYPE_NAME");
columns.Add("จำนวนคน", "PERSON_NO");
columns.Add("จำนวนเงิน", "SUBPAYMENT_AMOUNT");
columns.Add("วันที่จ่ายย่อย", "SUBPAYMENT_DATE");
var res = biz.GetGroupPayment(IdParameter, Convert.ToDateTime(txtStartPaidSubDate.Text), Convert.ToDateTime(txtEndPaidSubDate.Text), Convert.ToString(base.UserProfile.MemberType), txtID.Text, 1, base.EXCEL_SIZE_Key, "N");
export.CreateExcel(res.DataResponse, columns);
}
}
catch { }
}
protected void btnSavePopup_Click(object sender, EventArgs e)
{
string ref1 = string.Empty;
var biz = new BLL.PaymentBiz();
var res = biz.NewCreatePayment(lsOderInvoice.ToArray(), txtRemark.Text, base.UserId, base.UserProfile.CompCode, Convert.ToString(base.UserProfile.MemberType), out ref1);
if (res.IsError)
{
//var errorMsg = res.ErrorMsg;
//AlertMessage.ShowAlertMessage(string.Empty, errorMsg);
this.MasterSite.ModelError.ShowMessageError = res.ErrorMsg;
this.MasterSite.ModelError.ShowModalError();
GetDataInGridView();
}
else
{
GetDataInGridView();
this.MasterSite.ModelSuccess.ShowMessageSuccess = Resources.errorSysMessage_CreatePaymentSuccess;
this.MasterSite.ModelSuccess.ShowModalSuccess();
lsOderInvoice.Clear();
}
}
protected void BindPage()
{
PAGE_SIZE = Convert.ToInt32(txtInputMaxrow.Text);
var biz = new BLL.PaymentBiz();
var resultPage = txtNumberGvSearch.Text.ToInt();
string IdParameter;
if (base.UserProfile.MemberType == 1)
{
IdParameter = base.UserProfile.Id;
}
else
{
IdParameter = base.UserProfile.CompCode;
}
var res = biz.GetGroupPayment(IdParameter, Convert.ToDateTime(txtStartPaidSubDate.Text), Convert.ToDateTime(txtEndPaidSubDate.Text), Convert.ToString(base.UserProfile.MemberType), txtID.Text, resultPage, PAGE_SIZE, "N");
gvPaymentAssimilate.Visible = true;
gvPaymentAssimilate.DataSource = res.DataResponse;
gvPaymentAssimilate.DataBind();
boxresult.Visible = true;
}
private void BindDataInGridView()
{
//PAGE_SIZE = PAGE_SIZE_Key;
PAGE_SIZE = Convert.ToInt16(txtInputMaxrow.Text);
gvSearch.Visible = true;
var resultPage = txtNumberGvSearch.Text.ToInt();
var biz = new BLL.PaymentBiz();
var resCount = biz.GetPaymentLicenseAppove(ddlTypePay.SelectedValue.ToString(), txtIdCard.Text,
txtOrder.Text, Convert.ToDateTime(txtStartDate.Text)
, Convert.ToDateTime(txtEndDate.Text), txtFirstName.Text, txtLastName.Text, "Y", resultPage, PAGE_SIZE);
DataSet ds = resCount.DataResponse;
DataTable dt = ds.Tables[0];
DataRow drLicense = ds.Tables[0].Rows[0];
int rowCount = Convert.ToInt32(drLicense["rowcount"].ToString());
double dblPageCount = (double)((decimal)rowCount / PAGE_SIZE);
TotalPages = (int)Math.Ceiling(dblPageCount);
txtTotalPage.Text = Convert.ToString(TotalPages);
var res = biz.GetPaymentLicenseAppove(ddlTypePay.SelectedValue.ToString(), txtIdCard.Text,
txtOrder.Text, Convert.ToDateTime(txtStartDate.Text)
, Convert.ToDateTime(txtEndDate.Text), txtFirstName.Text, txtLastName.Text, "N", resultPage, PAGE_SIZE);
if (res.IsError)
{
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
gvSearch.DataSource = res.DataResponse;
gvSearch.DataBind();
gvSearch.Visible = true;
if (TotalPages == 0)
{
divGv1.Visible = true;
txtNumberGvSearch.Visible = true;
lblParaPage.Visible = true;
txtTotalPage.Visible = true;
btngo.Visible = true;
lblTotalrecord.Text = "0";
txtTotalPage.Text = "1";
txtInputMaxrow.Visible = true;
lblHeadInputMaxrow.Visible = true;
lblHeadTotal.Visible = true;
lblTotalrecord.Visible = true;
lblEndTotal.Visible = true;
CheckBox ckall = (CheckBox)gvSearch.HeaderRow.FindControl("Checkall");
ckall.Visible = false;
}
else if (TotalPages > 1)
{
txtNumberGvSearch.Visible = true;
lblParaPage.Visible = true;
txtTotalPage.Visible = true;
btnNextGvSearch.Visible = true;
btnPreviousGvSearch.Visible = false;
btngo.Visible = true;
lblTotalrecord.Text = drLicense["rowcount"].ToString();
txtInputMaxrow.Visible = true;
lblHeadInputMaxrow.Visible = true;
lblHeadTotal.Visible = true;
lblTotalrecord.Visible = true;
lblEndTotal.Visible = true;
btnGenLicense.Visible = true;
divGv1.Visible = true;
}
else if (TotalPages == 1)
{
txtNumberGvSearch.Visible = true;
lblParaPage.Visible = true;
txtTotalPage.Visible = true;
btnGenLicense.Visible = true;
btngo.Visible = true;
btnPreviousGvSearch.Visible = false;
lblTotalrecord.Text = drLicense["rowcount"].ToString();
txtInputMaxrow.Visible = true;
lblHeadInputMaxrow.Visible = true;
lblHeadTotal.Visible = true;
lblTotalrecord.Visible = true;
lblEndTotal.Visible = true;
divGv1.Visible = true;
}
if (gvSearch.Rows.Count == 0)
{
btnGenLicense.Visible = false;
}
else
{
btnGenLicense.Visible = true;
}
//UpdatePanelSearch.Update();
}
}
