//Pongsarun 1/3/2016: use for config system public string updateBankCode(BankCodeData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update BANK Set BANK_THAINAME = '" + updateData.Bank_ThaiName + "', BANK_ENGNAME='" + updateData.Bank_EngName + "', BANK_SHORTNAME='" + updateData.Bank_ShortName + "', BANK_LOGO='" + updateData.Bank_Logo + "', BANK_SERVICE_CODE='" + updateData.Bank_Service_code + "', BANK_CHARG='" + updateData.Bank_Charge + "' Where BANK_CODE='" + updateData.Bank_Code + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:System Config:Update BankCode" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
//Pongsarun 1/3/2016: use for config system public string insertBankCode(BankCodeData dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into BANK(BANK_CODE, BANK_THAINAME, BANK_ENGNAME, BANK_SHORTNAME, BANK_LOGO, BANK_SERVICE_CODE, BANK_CHARG) Values('" + dataInsert.Bank_Code + "','" + dataInsert.Bank_ThaiName + "','" + dataInsert.Bank_EngName + "','" + dataInsert.Bank_ShortName + "','" + dataInsert.Bank_Logo + "','" + dataInsert.Bank_Service_code + "','" + dataInsert.Bank_Charge + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:System Config:Insert BankCode" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
//Pongsarun 1/3/2016: use for config system public List <BankCodeData> getBankCodeManual(string sql) { List <BankCodeData> bankcodeData = new List <BankCodeData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { BankCodeData bankcode_data = new BankCodeData(); bankcode_data.Bank_Code = rowData["BANK_CODE"].ToString(); bankcode_data.Bank_ThaiName = rowData["BANK_THAINAME"].ToString(); bankcode_data.Bank_EngName = rowData["BANK_ENGNAME"].ToString(); bankcode_data.Bank_ShortName = rowData["BANK_SHORTNAME"].ToString(); bankcode_data.Bank_Logo = rowData["BANK_LOGO"].ToString(); bankcode_data.Bank_Service_code = rowData["BANK_SERVICE_CODE"].ToString(); bankcode_data.Bank_Charge = rowData["BANK_CHARG"].ToString(); bankcodeData.Add(bankcode_data); } return(bankcodeData); }
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 BankData getErrBankData(string payment_id, string payment_date, string payment_time, string degree_char) { Status_Variable status_var = new Status_Variable(); BankData bank_data = new BankData(); string TableName = getTableName(degree_char); string sql = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); sql = "Select * From " + TableName + " Where PAYMENT_ID = '" + payment_id + "' And PAYMENT_DATE='" + payment_date + "' And PAYMENT_TIME = '" + payment_time + "'"; oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { DegreeData degree_data = new DegreeData(); bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray(); bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray(); bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode)); bank_data.Bank_ShortName = bankcode_data.Bank_ShortName; bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName; bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray(); bank_data.Student_Name = rowData["STUDENT_NAME"].ToString(); bank_data.Student_ID = rowData["STUDENT_ID"].ToString(); bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString(); bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString(); bank_data.Semester = rowData["SEMESTER"].ToString(); bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString(); bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString(); bank_data.Payment_Time = rowData["PAYMENT_TIME"].ToString(); bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date); bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1); degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level); bank_data.Degree_Char = degree_data.Degree_Char; bank_data.Degree_ThaiName = degree_data.Degree_Thai; bank_data.DueDate = rowData["DUE_DATE"].ToString(); bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate); bank_data.SumDate = rowData["BANK_SUMDATE"].ToString(); bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate); bank_data.Status = rowData["STATUS"].ToString(); } return(bank_data); }
public BankCodeData getBankCode(string bank_code) { BankCodeData bankcode_data = new BankCodeData(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From BANK Where BANK_CODE='" + bank_code + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { bankcode_data.Bank_Code = rowData["BANK_CODE"].ToString(); bankcode_data.Bank_ThaiName = rowData["BANK_THAINAME"].ToString(); bankcode_data.Bank_EngName = rowData["BANK_ENGNAME"].ToString(); bankcode_data.Bank_ShortName = rowData["BANK_SHORTNAME"].ToString(); bankcode_data.Bank_Logo = rowData["BANK_LOGO"].ToString(); bankcode_data.Bank_Service_code = rowData["BANK_SERVICE_CODE"].ToString(); bankcode_data.Bank_Charge = rowData["BANK_CHARG"].ToString(); } return(bankcode_data); }
// V 1.0.0 public List <BankData> getBankData_AllDegree(string selected_date) { List <BankData> bankData = new List <BankData>(); string sql = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); sql = "Select * From BANK_DATA Where BANK_SUMDATE = '" + selected_date + "' "; oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { BankData bank_data = new BankData(); DegreeData degree_data = new DegreeData(); bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray(); bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray(); bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode)); bank_data.Bank_ShortName = bankcode_data.Bank_ShortName; bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName; bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray(); bank_data.Student_Name = rowData["STUDENT_NAME"].ToString(); bank_data.Student_ID = rowData["STUDENT_ID"].ToString(); bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString(); bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString(); bank_data.Semester = rowData["SEMESTER"].ToString(); bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString(); bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString(); bank_data.Payment_Time = rowData["PAYMENT_TIME"].ToString(); bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date); bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1); degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level); bank_data.Degree_Char = degree_data.Degree_Char; bank_data.Degree_ThaiName = degree_data.Degree_Thai; bank_data.DueDate = rowData["DUE_DATE"].ToString(); bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate); bank_data.SumDate = rowData["BANK_SUMDATE"].ToString(); bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate); bank_data.Status = rowData["STATUS"].ToString(); bankData.Add(bank_data); } sql = "Select * From GRAD_BANK_DATA Where BANK_SUMDATE = '" + selected_date + "' "; oracleObj.SelectCommand = sql; DataView allData2 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData2) { BankData bank_data = new BankData(); DegreeData degree_data = new DegreeData(); bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray(); bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray(); bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode)); bank_data.Bank_ShortName = bankcode_data.Bank_ShortName; bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName; bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray(); bank_data.Student_Name = rowData["STUDENT_NAME"].ToString(); bank_data.Student_ID = rowData["STUDENT_ID"].ToString(); bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString(); bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString(); bank_data.Semester = rowData["SEMESTER"].ToString(); bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString(); bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString(); bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date); bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1); degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level); bank_data.Degree_Char = degree_data.Degree_Char; bank_data.Degree_ThaiName = degree_data.Degree_Thai; bank_data.DueDate = rowData["DUE_DATE"].ToString(); bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate); bank_data.SumDate = rowData["BANK_SUMDATE"].ToString(); bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate); bank_data.Status = rowData["STATUS"].ToString(); bankData.Add(bank_data); } return(bankData); }
// V 1.0.0 private void setBankData() { int start = 0; int dataLength = charData.Length; if (charData[start] == 'H') { Array.Copy(charData, start + 0, head_data.RecType, 0, 1); Array.Copy(charData, start + 1, head_data.SeqNo, 0, 6); Array.Copy(charData, start + 7, head_data.BankCode, 0, 3); Array.Copy(charData, start + 10, head_data.CompAccount, 0, 10); Array.Copy(charData, start + 20, head_data.CompName, 0, 40); Array.Copy(charData, start + 60, head_data.EffDate, 0, 8); Array.Copy(charData, start + 68, head_data.ServiceCode, 0, 8); bankcode_data = bankcodeObj.getBankCode(new string(head_data.BankCode)); head_data.Bank_ShortName = bankcode_data.Bank_ShortName; head_data.Bank_ThaiName = bankcode_data.Bank_ThaiName; head_data.Bank_SummaryDate = convertPaymentdate(head_data.EffDate); DegreeData degree_data = new DegreeData(); DegreeAdmission degreeObj = new DegreeAdmission(); start += 258; if (charData[start] == 'D') { for (int offset = start; offset < dataLength; offset = offset + 258) { if (charData[offset] == 'D') { BankData bank_data = new BankData(); numOfData++; Array.Copy(charData, offset + 0, bank_data.RecType, 0, 1); Array.Copy(charData, offset + 1, bank_data.SeqNo, 0, 6); Array.Copy(charData, offset + 7, bank_data.BankCode, 0, 3); Array.Copy(charData, offset + 10, bank_data.CompAccount, 0, 10); Array.Copy(charData, offset + 20, bank_data.PayDate, 0, 8); Array.Copy(charData, offset + 28, bank_data.PayTime, 0, 6); Array.Copy(charData, offset + 34, bank_data.CustomerName, 0, 50); Array.Copy(charData, offset + 84, bank_data.Ref1, 0, 20); Array.Copy(charData, offset + 104, bank_data.Ref2, 0, 20); Array.Copy(charData, offset + 124, bank_data.Ref3, 0, 20); Array.Copy(charData, offset + 144, bank_data.BranNo, 0, 4); Array.Copy(charData, offset + 148, bank_data.TellerNo, 0, 4); Array.Copy(charData, offset + 152, bank_data.KindTranc, 0, 1); Array.Copy(charData, offset + 153, bank_data.TrancCode, 0, 3); Array.Copy(charData, offset + 156, bank_data.CheqNo, 0, 7); Array.Copy(charData, offset + 163, bank_data.Amount, 0, 13); Array.Copy(charData, offset + 176, bank_data.CheqCode, 0, 3); bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode)); bank_data.Bank_ShortName = bankcode_data.Bank_ShortName; bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName; bank_data.Student_ID = new string(bank_data.Ref1, 0, 13); //bank_data.Nation_ID = new string(bank_data.Ref1,0,13); //bank_data.Passport_ID = new string(bank_data.Ref1,0, 13); bank_data.AcademicYear = "25" + new string(bank_data.Ref1, 13, 2); bank_data.Semester = new string(bank_data.Ref1, 15, 1); bank_data.Degree_Level = new string(bank_data.Ref2, 0, 1); bank_data.Paymenty_ID = new string(bank_data.Ref2, 0, 10); bank_data.Payment_Date = convertPaymentdate(bank_data.PayDate); bank_data.Payment_Time = new string(bank_data.PayTime); bank_data.ThaiPayment_Date = thaipaymentdate(bank_data.PayDate); bank_data.Money = new string(bank_data.Amount).TrimStart('0'); bank_data.Money = String.Format("{0:#,###,###.00}", Convert.ToDecimal(bank_data.Money) / 100); degree_data = degreeObj.getDegreeAdmission(bank_data.Degree_Level); bank_data.Degree_Char = degree_data.Degree_Char; bank_data.Degree_ThaiName = degree_data.Degree_Thai; char[] tmpduedate = new char[6]; Array.Copy(bank_data.Ref2, 10, tmpduedate, 0, 6); bank_data.DueDate = convertDuedate(tmpduedate); bank_data.ThaiDueDate = thaiduedate(tmpduedate); bankData.Add(bank_data); } } } else { ErrorResponse = "No Data Section"; } } else { ErrorResponse = "No Head Section"; } }
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"); } } }