private void AddRequestChange(DTO.BankTransaction banktransection)
{
if (banktransection != null)
{
ChangeDataRequest.Add(banktransection);
}
}
protected void chkgvPaymentLate_CheckedChanged(Object sender, EventArgs e)
{
var gv = (GridViewRow)((CheckBox)sender).NamingContainer;
CheckBox _chkgvPaymentLate = (CheckBox)gv.FindControl("chkgvPaymentLate");
Label _lblgvPaymentLateStatus = (Label)gv.FindControl("lblgvPaymentLateStatus");
Label _lblgvPaymentLateRef1 = (Label)gv.FindControl("lblgvPaymentLateRef1");
Label _lblgvPaymentLateId = (Label)gv.FindControl("lblgvPaymentLateId");
DTO.BankTransaction result = GvPaymentLateSource.FirstOrDefault(a => a.Id == _lblgvPaymentLateId.Text);
result.Selected = _chkgvPaymentLate.Checked;
if (_chkgvPaymentLate.Checked)
{
_lblgvPaymentLateStatus.Text = "นำเข้า";
_lblgvPaymentLateStatus.ForeColor = System.Drawing.Color.Green;
}
else
{
_lblgvPaymentLateStatus.Text = "ไม่นำเข้า";
_lblgvPaymentLateStatus.ForeColor = System.Drawing.Color.Red;
}
_lblgvPaymentLateStatus.DataBind();
}
protected void btnSelectedMappingPaymentMissing_OnClick(Object sender, EventArgs e)
{
var gv = (GridViewRow)((Button)sender).NamingContainer;
Label paymentID = (Label)gv.FindControl("lblPaymentRefNo");
Label paymentAmount = (Label)gv.FindControl("lblPaymentAmount");
DTO.BankTransaction bankTransaction = GvPaymentMissingSource.SingleOrDefault(a => a.Id == txtFindPaymentSelected.Text);
bankTransaction.ChangeRef1 = paymentID.Text;
bankTransaction.ChangeAmount = paymentAmount.Text;
gvPaymentMissing.DataSource = GvPaymentMissingSource;
gvPaymentMissing.DataBind();
txtFindPaymentSelected.Text = "";
}
public DTO.UploadResult <DTO.SummaryBankTransaction, DTO.BankTransaction> ValidateData()
{
DTO.UploadResult <DTO.SummaryBankTransaction, DTO.BankTransaction> result = new DTO.UploadResult <DTO.SummaryBankTransaction, DTO.BankTransaction>();
result.Header = new List <DTO.SummaryBankTransaction>();
result.Detail = new List <DTO.BankTransaction>();
result.GroupId = this.ID;
foreach (CityFileDetail item in this.CityFileDetails)
{
DTO.BankTransaction detail = new DTO.BankTransaction()
{
Id = item.ID,
SequenceNo = item.SequenceNo,
PaymentDate = ParseDateFromString.ParseDateHeaderBank(item.PAYMENT_DATE).ToString("dd/MM/yyyy"), // .Format("{0}/{1}/{2}", item.PAYMENT_DATE.Substring(0, 2), item.PAYMENT_DATE.Substring(2, 2), item.PAYMENT_DATE.Substring(4, 4)),
CustomerName = item.CUSTOMER_NAME,
Ref1 = item.CUSTOMER_NO_REF1,
Ref2 = item.REF2,
ChequeNo = item.CHEQUE_NO,
Amount = PhaseAmountHelper.ConvertStringAmountCity(item.AMOUNT),
AccountNo = item.COMPANY_ACCOUNT,
};
detail.ErrorMessage = (item.GetBrokenRules().Count() > 0) ? item.GetBrokenRules().First().Rule : "";
detail.Status = (int)item.Status;
if (item.Status == DTO.ImportPaymentStatus.Paylate)
{
detail.ErrorMessage += String.Format("- นำส่งล้าช้า <br />");
}
result.Detail.Add(detail);
}
Int32 countDetail = CityFileDetails.Count();
Int32 countOfInvalid = result.Detail.Where(a => !String.IsNullOrEmpty(a.ErrorMessage)).Count();
Decimal sumAmount = PhaseAmountHelper.ConvertStringAmountCity(CityFileTotal.TOTAL_CREDIT_AMOUNT);
DTO.SummaryBankTransaction sumary = new DTO.SummaryBankTransaction()
{
UploadDate = DateTime.Today,
FileName = FileName,
NumberOfItems = countDetail,
NumberOfValid = countDetail - countOfInvalid,
NumberOfInValid = countOfInvalid,
Total = this.TotalAmount,
};
//foreach (CityFileTotal item in this.CityFileTotals)
//{
// if (item.GetBrokenRules().Count() > 0)
// {
// sumary.ErrMessage = this.CityFileTotal.GetBrokenRules().First().Rule;
// break;
// }
//}
Decimal sumDetail = this.CityFileDetails.Sum(a => PhaseAmountHelper.ConvertStringAmountCity(a.AMOUNT));
if (sumary.Total != sumDetail)
{
sumary.ErrMessage = "จำนวนเงินรวม เอกสารไม่ถูกต้อง";
}
result.Header.Add(sumary);
return(result);
}
protected void bntConfirmChange_Click(Object sender, EventArgs e)
{
pnlConfirmImportList.Visible = false;
if (GvCheckListSource.Count() > 0)
{
if (GvPaymentLateSource.Count() > 0)
{
foreach (DTO.BankTransaction item in GvPaymentLateSource)
{
DTO.BankTransaction data = GvCheckListSource.FirstOrDefault(a => a.Id == item.Id);
if (item.Selected)
{
data.ErrorMessage = "(อนุมัตินำเข้า) นำส่งล่าช้า ";
}
else
{
var result = GvCheckListSource.ToList();
result.Remove(data);
Session["gvCheckListSource"] = result;
}
}
}
if (GvPaymentMissingSource.Count() > 0)
{
foreach (DTO.BankTransaction item in GvPaymentMissingSource)
{
DTO.BankTransaction data = GvCheckListSource.FirstOrDefault(a => a.Id == item.Id);
if (String.IsNullOrEmpty(item.ChangeRef1))
{
var result = GvCheckListSource.ToList();
result.Remove(data);
Session["gvCheckListSource"] = result;
}
else
{
data.ChangeRef1 = item.ChangeRef1;
data.ChangeAmount = item.ChangeAmount;
data.ErrorMessage = String.Format("เปลี่ยน เลขที่ใบสั่งจ่ายเป็น {0}", item.ChangeRef1);
}
}
}
if (GvPaymentInvalidSource.Count() > 0)
{
foreach (DTO.BankTransaction item in GvPaymentInvalidSource)
{
DTO.BankTransaction data = GvCheckListSource.FirstOrDefault(a => a.Id == item.Id);
var result = GvCheckListSource.ToList();
result.Remove(data);
Session["gvCheckListSource"] = result;
}
}
btnImport.Enabled = true;
btnImport.Visible = true;
pnlImportFile.Visible = true;
Int32 getResult = GvCheckListSource.Count();
SummaryUploadSource.NumberOfValid = getResult;
SummaryUploadSource.NumberOfInValid = SummaryUploadSource.NumberOfItems - getResult;
gvImportFile.DataSource = GvImportFileSource;
gvImportFile.DataBind();
//if (GvCheckListSource.Where(a => !String.IsNullOrEmpty(a.ErrorMessage)).Count() > 0)
//{
// lblMessageError.Text = Resources.errorPayRenewFee_001;
// lblMessageError.Visible = true;
// btnImport.Enabled = false;
// btnImport.Visible = false;
// Button1.Visible = true;
// Button1.Enabled = true;
//}
//else if (!String.IsNullOrEmpty(SummaryUploadSource.ErrMessage))
//{
// lblMessageError.Text = SummaryUploadSource.ErrMessage;
// lblMessageError.Text = String.Format("ไม่สามารถนำเข้าข้อมูลได้ เนื่องจาก {0}!!!", SummaryUploadSource.ErrMessage);
// lblMessageError.Visible = true;
// btnImport.Enabled = false;
// btnImport.Visible = false;
// Button1.Visible = true;
// Button1.Enabled = true;
//}
//else if (GvCheckListSource.Count() <= 0)
//{
// btnImport.Enabled = false;
// btnImport.Visible = false;
// Button1.Visible = true;
// Button1.Enabled = true;
//}
if (GvCheckListSource.Count() > 0)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("th-TH");
gvCheckList.DataSource = GvCheckListSource;
gvCheckList.DataBind();
}
}
}
