protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
code = Request.QueryString["token"];
if (!Page.IsPostBack)
{
BankCodeData data = new BankCode().getBankCode(code);
txtBANK_CODE.Text = data.Bank_Code;
txtBANK_THAINAME.Text = data.Bank_ThaiName;
txtBANK_ENGNAME.Text = data.Bank_EngName;
txtBANK_SHORTNAME.Text = data.Bank_ShortName;
txtBANK_SERVICE_CODE.Text = data.Bank_Service_code;
txtBANK_CHARG.Text = data.Bank_Charge;
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
public ABSAController(ILoggerFactory loggerFactory, IOptions <SimAppSettings> appSettings)
{
this.appSettings = appSettings;
this.logger = loggerFactory.CreateLogger <ABSAController>();
this.bankService = new BankAccountService(loggerFactory, appSettings);
this.bCode = BankCode.ABSA;
}
public BankAccount(string number, string agency, BankCode code, int userId)
{
Number = number;
Agency = agency;
Code = code.Value;
UserId = userId;
}
/// <summary>
/// 获取银行列表
/// </summary>
/// <returns></returns>
public static BankCode GetBankCodeList()
{
string path = Path.Combine(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase, @"XmlConfig\BankCode.xml");
BankCode bankCode = ConfigHelper.XmlDeserializeFromFile <BankCode>(path, Encoding.Default);
return(bankCode);
}
/// <summary>
/// Gets the hash code
/// </summary>
/// <returns>Hash code</returns>
public override int GetHashCode()
{
unchecked // Overflow is fine, just wrap
{
var hashCode = 41;
// Suitable nullity checks etc, of course :)
if (AccountNumber != null)
{
hashCode = hashCode * 59 + AccountNumber.GetHashCode();
}
if (BankCode != null)
{
hashCode = hashCode * 59 + BankCode.GetHashCode();
}
if (BankName != null)
{
hashCode = hashCode * 59 + BankName.GetHashCode();
}
if (BranchCode != null)
{
hashCode = hashCode * 59 + BranchCode.GetHashCode();
}
if (CheckDigit != null)
{
hashCode = hashCode * 59 + CheckDigit.GetHashCode();
}
if (CountryCode != null)
{
hashCode = hashCode * 59 + CountryCode.GetHashCode();
}
return(hashCode);
}
}
protected override string GenerateBankFileFooter()
{
string[] bankFileFooter = new string[7];
bankFileFooter[0] = "CI";
bankFileFooter[1] = BankCode.PadRight(3).Substring(0, 3) + BranchCode.PadRight(3).Substring(0, 3) + AccountNo.PadRight(8).Substring(0, 8);
bankFileFooter[2] = this.AccountHolderName.ToUpper().PadRight(50).Substring(0, 50);
if (FileType == FileTypeEnum.Autopay)
{
bankFileFooter[3] = "CR";
bankFileFooter[4] = ValueDate.ToString("yyyyMMdd");
bankFileFooter[5] = RecordCount.ToString("00000");
bankFileFooter[6] = TotalAmount.ToString("0.00").PadLeft(12);
string bankFileFooterData = string.Join(FIELD_DELIMITER, bankFileFooter);
if (bankFileFooterData.Length != 93)
{
throw (new Exception("Incorrect Detail Length of Payment for Footer"));
}
return(bankFileFooterData);
}
else
{
bankFileFooter[3] = ValueDate.ToString("yyyyMMdd");
bankFileFooter[4] = RecordCount.ToString("00000");
bankFileFooter[5] = TotalAmount.ToString("0.00").PadLeft(12);
bankFileFooter[6] = string.Empty.PadLeft(7);
string bankFileFooterData = string.Join(FIELD_DELIMITER, bankFileFooter);
if (bankFileFooterData.Length != 98)
{
throw (new Exception("Incorrect Detail Length of Payment for Footer"));
}
return(bankFileFooterData);
}
}
public override int GetHashCode()
{
int hashType = Type == null ? 0 : Type.GetHashCode();
int hashBankCode = BankCode.GetHashCode();
int hashAccountId = AccountId.GetHashCode();
return(hashType ^ hashBankCode ^ hashAccountId);
}
protected void btnOK_Click(object sender, EventArgs e)
{
string result = new BankCode().deleteBankCode(code);
if (result == "OK")
{
Response.Redirect("list_Bank.aspx");
}
}
public void TestService ()
{
// BEA Weblogic / RPC
BankCode bc = new BankCode ();
Assert.AreEqual ("10020000 ", bc.getCodeByName ("Berlin"), "#1");
string s = bc.getNameByCode ("10020000 ");
Assert.AreEqual ("10020000 ", bc.getCodeByName (s), "#2");
}
public void TestService()
{
// BEA Weblogic / RPC
BankCode bc = new BankCode();
Assert.AreEqual("10020000 ", bc.getCodeByName("Berlin"), "#1");
string s = bc.getNameByCode("10020000 ");
Assert.AreEqual("10020000 ", bc.getCodeByName(s), "#2");
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
BankCodeData bankData = new BankCodeData();
bankData.Bank_Code = txtBANK_CODE.Text;
bankData.Bank_ThaiName = txtBANK_THAINAME.Text;
bankData.Bank_EngName = txtBANK_ENGNAME.Text;
bankData.Bank_ShortName = txtBANK_SHORTNAME.Text;
bankData.Bank_Service_code = txtBANK_SERVICE_CODE.Text;
bankData.Bank_Charge = txtBANK_CHARG.Text;
if (fileBANK_LOGO.HasFile)
{
FileName = Path.GetFileName(fileBANK_LOGO.PostedFile.FileName);
Extension = Path.GetExtension(fileBANK_LOGO.PostedFile.FileName);
FolderPath = ConfigurationManager.AppSettings["ImageUploadFolder"];
//หากต้องการเปลี่ยนชื่อไฟล์ที่ใช้ upload
//string newName = new TQF1().getTqf1Id();
//FileName = newName + Extension;
string FilePath = Server.MapPath(FolderPath + FileName);
if (Extension == ".jpg" || Extension == ".png")
{
fileBANK_LOGO.SaveAs(FilePath);
}
else
{
Session["response"] = "add_Bank: ไฟล์ upload ต้องเป็นไฟล์นามสกุล .jpg หรือ .png เท่านั้น";
Response.Redirect("../err_response.aspx");
}
}
if (FileName == "" || fileBANK_LOGO.FileName == "")
{
BankCodeData data = new BankCode().getBankCode(code);
lblBANK_CODE.Text = data.Bank_Logo;
bankData.Bank_Logo = data.Bank_Logo;
}
else
{
bankData.Bank_Logo = FileName;
}
string bankUpdate = new BankCode().updateBankCode(bankData);
if (bankUpdate == "OK")
{
Response.Redirect("list_Bank.aspx");
}
}
public async Task <IEnumerable <FileStatusDTO> > ReadTransactionsFromFiles(CsvFileReaderDTO dto)
{
IBankEstatementReader reader = _readerResolver.GetBankEstatementReader(BankCode.FromValue <BankCode>(dto.BankCode));
var fileStatusResult = new List <FileStatusDTO>();
foreach (var csv in dto.CsvFiles)
{
var fileStatus = new FileStatusDTO
{
FileName = csv.FileName
};
try
{
Validate.IsTrue(csv.ContentType == "text/csv", "Only csv files are accepted");
Validate.IsTrue(csv.Length > 0, $"File {csv.FileName} is empty");
var parsedFile = reader.ProcessBankInformation(csv);
fileStatus.TransactionsRead = parsedFile.Transactions.Count;
var bankAccount = await GetFilesOwnerBankAccount(dto.FilesOwnerId, parsedFile.AgencyNumber, parsedFile.AccountNumber, dto.BankCode);
RemoveExistentTransactions(parsedFile);
if (parsedFile.Transactions.Count > 0)
{
await PersistBankEstatementInformation(parsedFile, bankAccount);
}
fileStatus.IsSuccessfullRead = true;
fileStatus.TransactionsSaved = parsedFile.Transactions.Count;
// TODO: Get initial and final date from file
fileStatus.InitialDate = parsedFile.Transactions.First().Date;
fileStatus.FinalDate = parsedFile.Transactions.Last().Date;
}
catch (Exception ex)
{
// TODO: create exception for file and reading cases, and another for database cases
_logger.LogWarning("Message: {0}", ex.Message);
fileStatus.IsSuccessfullRead = false;
}
finally
{
fileStatusResult.Add(fileStatus);
}
}
return(fileStatusResult);
}
public bool Equals([AllowNull] BankAccount other)
{
if (other is null)
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return(BankCode.Equals(other.BankCode) && AccountId.Equals(other.AccountId) && Type.Equals(other.Type));
}
public IBankEstatementReader GetBankEstatementReader(BankCode bank)
{
if (bank.Name == BankCode.BRADESCO.Name)
{
return((IBankEstatementReader)_serviceProvider.GetService(typeof(BradescoReader)));
}
//if (readerName.Name == BankCode.ITAU.Name)
// return (IBankEstatementReader)_serviceProvider.GetService(typeof(ItauReader));
//if (readerName.Name == BankCode.BANCODOBRASIL.Name)
// return (IBankEstatementReader)_serviceProvider.GetService(typeof(BancoDoBrasilReader));
throw new ArgumentException($"{bank.Name} is not supported yet.");
}
public static DataProviderResultModel GetBankCodes()
{
DataBaseOperator dbo = null;
List <BankCode> infos = new List <BankCode>();
DataProviderResultModel result = new DataProviderResultModel();
try
{
dbo = new DataBaseOperator();
ParamCollections pc = new ParamCollections();
string sqlStr = @"select bankCode,bankName from IFBanksCode where status = 1 order by bankName";
DataTable dt = dbo.GetTable(sqlStr, pc.GetParams());
if (null != dt && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
BankCode info = new BankCode();
info.bankCode = Convert.ToString(dt.Rows[i]["bankCode"]);
info.bankName = Convert.ToString(dt.Rows[i]["bankName"]);
infos.Add(info);
}
}
result.result = Result.SUCCESS;
result.data = infos;
return(result);
}
catch (Exception ex)
{
result.result = Result.ERROR;
result.message = "The database logic error.The function is MainInfoProvider::GetBankCodes";
Log.WriteErrorLog("MainInfoProvider::GetBankCodes", "获取失败，异常：{0}", ex.Message);
}
finally
{
if (null != dbo)
{
dbo.Close();
dbo = null;
}
}
return(result);
}
protected override string GenerateBankFileHeader()
{
string[] bankFileHeader = new string[5];
bankFileHeader[0] = m_BatchID.PadRight(5).Substring(0, 5).Trim();
bankFileHeader[1] = ((int)m_TransactionType).ToString("00");
string companyAccountNo = BankCode.PadRight(3).Substring(0, 3) + "-" + BranchCode.PadRight(3).Substring(0, 3) + "-" + AccountNo.PadRight(9).Substring(0, 9).Trim();
bankFileHeader[2] = companyAccountNo;
bankFileHeader[3] = AccountHolderName.PadRight(20).Substring(0, 20);
bankFileHeader[4] = m_BatchName;
string bankFileHeaderData = "\"" + string.Join(FIELD_DELIMITER, bankFileHeader) + "\"";
//if (bankFileHeaderDetail.Length != 83)
// throw new Exception("Incorrect Bank File Header Length:\r\n" + bankFileHeaderDetail);
return(bankFileHeaderData);
}
public async Task <IEnumerable <BankAccountsResponseDTO> > GetUserBankAccounts(GetUserBankAccountsDTO dto)
{
var bankAccounts = await _bankAccountRepository.GetAllByUser(dto.UserId);
Validate.IsTrue(bankAccounts.Count() > 0, "No bank accounts were found");
var bankAccountsDto = bankAccounts.Select(bk => new BankAccountsResponseDTO
{
Id = bk.Id,
Agency = bk.Agency,
AccountNumber = bk.Number,
BankCode = bk.Code,
BankName = BankCode.FromValue <BankCode>(bk.Code).Name,
UserId = (int)bk.UserId
});
return(bankAccountsDto);
}
public async Task UpdateBankAccount(UpdateUserBankAccountDTO dto)
{
var bankAccount = await _bankAccountRepository.GetById(dto.BankAccountId);
Validate.NotNull(bankAccount, "Bank account not found");
Validate.IsTrue(bankAccount.UserId == dto.UserId, "Acesso negado");
BankCode.ValidateCode(dto.Code);
Validate.NotNullOrEmpty(dto.Agency, "É necessário fornecer uma agência.");
Validate.NotNullOrEmpty(dto.Number, "É necessário fornecer o número da conta bancária.");
bankAccount.SetAgency(dto.Agency);
bankAccount.SetNumber(dto.Number);
bankAccount.SetCode(dto.Code);
_bankAccountRepository.Update(bankAccount);
Validate.IsTrue(await _uow.CommitAsync(), "Ocorreu um problema na atualização");
}
public async Task <BankAccountResponseDTO> GetBankAccountById(GetUserBankAccountDTO dto)
{
var bankAccount = await _bankAccountRepository.GetById(dto.BankAccountId);
Validate.NotNull(bankAccount, "Bank account not found");
Validate.IsTrue(bankAccount.UserId == dto.UserId, "Acesso negado");
var response = new BankAccountResponseDTO()
{
Id = bankAccount.Id,
Agency = bankAccount.Agency,
AccountNumber = bankAccount.Number,
BankCode = bankAccount.Code,
BankName = BankCode.FromValue <BankCode>(bankAccount.Code).Name
};
return(response);
}
/// <summary>
/// Returns true if BankAccountBban instances are equal
/// </summary>
/// <param name="other">Instance of BankAccountBban to be compared</param>
/// <returns>Boolean</returns>
public bool Equals(BankAccountBban other)
{
if (ReferenceEquals(null, other))
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return
((
AccountNumber == other.AccountNumber ||
AccountNumber != null &&
AccountNumber.Equals(other.AccountNumber)
) &&
(
BankCode == other.BankCode ||
BankCode != null &&
BankCode.Equals(other.BankCode)
) &&
(
BankName == other.BankName ||
BankName != null &&
BankName.Equals(other.BankName)
) &&
(
BranchCode == other.BranchCode ||
BranchCode != null &&
BranchCode.Equals(other.BranchCode)
) &&
(
CheckDigit == other.CheckDigit ||
CheckDigit != null &&
CheckDigit.Equals(other.CheckDigit)
) &&
(
CountryCode == other.CountryCode ||
CountryCode != null &&
CountryCode.Equals(other.CountryCode)
));
}
public async Task CreateBankAccountForUser(CreateUserBankAccountDTO dto)
{
var user = await _userRepository.GetById(dto.UserId);
Validate.NotNull(user, "É necessário um usuário para criar uma conta de banco.");
Validate.NotNullOrEmpty(dto.Agency, "É necessário fornecer uma agência.");
Validate.NotNullOrEmpty(dto.Number, "É necessário fornecer o número da conta bancária.");
BankCode.ValidateCode(dto.Code);
var code = BankCode.FromValue <BankCode>(dto.Code);
var bankAccount = new BankAccount(dto.Number, dto.Agency, code, dto.UserId);
_bankAccountRepository.Insert(bankAccount);
Validate.IsTrue(await _uow.CommitAsync(), "Não foi possível criar a conta bancária");
}
protected override string GenerateBankFileHeader()
{
string[] bankFileHeader = new string[13];
// Record Type 9(1)
bankFileHeader[0] = "1";
// Service Type X(10)
bankFileHeader[1] = "IBGINORM ";
// Originating Bank Code 9(3)
bankFileHeader[2] = BankCode.PadRight(3).Substring(0, 3);
// Originating Branch Code 9(3)
bankFileHeader[3] = BranchCode.PadRight(3).Substring(0, 3);
// Originating Account No 9(11)
bankFileHeader[4] = ((string)("0" + AccountNo)).PadRight(11).Substring(0, 11);
// Originating A/C Name
bankFileHeader[5] = AccountHolderName.PadRight(20).Substring(0, 20);
// Creation Date 9(8)
bankFileHeader[6] = AppUtils.ServerDateTime().ToString("yyyyMMdd");
// Value Date 9(8)
bankFileHeader[7] = ValueDate.ToString("yyyyMMdd");
// Filler X(5)
bankFileHeader[8] = " ";
// Hash Indicator X(1)
bankFileHeader[9] = " ";
// Payment Advice Header Line1 X(105)
bankFileHeader[10] = "".PadRight(105);
// Payment Advice Header Line2 X(105)
bankFileHeader[11] = "".PadRight(105);
// Filler X(320)
bankFileHeader[12] = "".PadRight(320);
string bankFileHeaderData = string.Join(FIELD_DELIMITER, bankFileHeader);
if (bankFileHeaderData.Length != 600)
{
throw new Exception("Incorrect Bank File Header Length:\r\n" + bankFileHeaderData);
}
return(bankFileHeaderData);
}
public void CreateBankCodeXML()
{
string path = Path.Combine(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase, @"XmlConfig\BankCode.xml");
string str = FileHelper.ReadTextFile("bankCode.txt");
string[] strArr = str.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
var obj = new BankCode();
for (int i = 0; i < strArr.Length; i++)
{
string[] item = strArr[i].Split('\t');
if (item.Length >= 2)
{
obj.BankCodeList.Add(new KeyCode()
{
Desc = item[0].Trim(),
Key = item[1].Trim()
});
}
}
ConfigHelper.XmlSerializeToFile(obj, path, Encoding.Default);
}
public async Task <IActionResult> ReadBankStatements(IFormFileCollection csvFiles, [FromForm] short bankCode)
{
BankCode.ValidateCode(bankCode);
// TODO : better way to do this?
var user = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.NameIdentifier);
if (string.IsNullOrEmpty(user?.Value))
{
return(Unauthorized());
}
var dto = new CsvFileReaderDTO()
{
FilesOwnerId = int.Parse(user.Value),
BankCode = bankCode,
CsvFiles = csvFiles
};
var result = await _csvReaderService.ReadTransactionsFromFiles(dto);
return(Ok(result));
}
/// <param name="bankCode">کد بانک</param>
public Builder SetBankCode(BankCode bankCode)
{
this.bankCode = (int)bankCode;
return(this);
}
public ActionResult Index92(BankCode banks)
{
//PartialView 接收一個物件
return(PartialView(banks));
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
string sql = "Select * From BANK Where BANK_CODE='" + txtBANK_CODE.Text + "'";
List <BankCodeData> chkDup = new BankCode().getBankCodeManual(sql);
if (chkDup.Count > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('รหัสธนาคารซ้ำ!');", true);
}
else
{
BankCodeData bankData = new BankCodeData();
bankData.Bank_Code = txtBANK_CODE.Text;
bankData.Bank_ThaiName = txtBANK_THAINAME.Text;
bankData.Bank_EngName = txtBANK_ENGNAME.Text;
bankData.Bank_ShortName = txtBANK_SHORTNAME.Text;
bankData.Bank_Service_code = txtBANK_SERVICE_CODE.Text;
bankData.Bank_Charge = txtBANK_CHARG.Text;
if (fileBANK_LOGO.HasFile)
{
FileName = Path.GetFileName(fileBANK_LOGO.PostedFile.FileName);
Extension = Path.GetExtension(fileBANK_LOGO.PostedFile.FileName);
FolderPath = ConfigurationManager.AppSettings["ImageUploadFolder"];
//หากต้องการเปลี่ยนชื่อไฟล์ที่ใช้ upload
//string newName = new TQF1().getTqf1Id();
//FileName = newName + Extension;
string FilePath = Server.MapPath(FolderPath + FileName);
if (Extension == ".jpg" || Extension == ".png")
{
fileBANK_LOGO.SaveAs(FilePath);
}
else
{
Session["response"] = "add_Bank: ไฟล์ upload ต้องเป็นไฟล์นามสกุล .jpg หรือ .png เท่านั้น";
Response.Redirect("../err_response.aspx");
}
}
if (FileName == "" || fileBANK_LOGO.FileName == "")
{
bankData.Bank_Logo = "";
}
else
{
bankData.Bank_Logo = FileName;
}
string bankInsert = new BankCode().insertBankCode(bankData);
if (bankInsert == "OK")
{
Response.Redirect("list_Bank.aspx");
}
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
public CreditorAgent(BankCode bankCode)
{
this.bankCode = bankCode;
}
public CreateBank(BankCode bankCode)
{
BankCode = bankCode;
}
public BankCreated(int bankId, BankCode bankCode)
{
BankId = bankId;
BankCode = bankCode;
}
public override String ToString()
{
return(BankCode.ToString());
}
