private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
int Quantity = 0;
BackgroundWorker worker = sender as BackgroundWorker;
System.Threading.Thread.Sleep(2000);
t.NewTransaction(DateTime.Now, Action, AdminID);
foreach (DataGridViewRow row in dgvTransaction.Rows)
{
t.NewBorrowed(TransactionID, g.GetGENID(Borrower), Convert.ToInt32(row.Cells[0].Value), DateTime.Now, Convert.ToInt32(row.Cells[2].Value), false);
t.BorrowableEditQuantity(Convert.ToInt32(row.Cells[0].Value), g.GetEquipmentBorrowableQuantity(Convert.ToInt32(row.Cells[0].Value)) + Convert.ToInt32(row.Cells[2].Value));
Quantity = Quantity + Convert.ToInt32(row.Cells[2].Value);
}
s.GenerateBarcode(TransactionID.ToString());
db.sp_UserBorrowAdd(g.GetGENID(Borrower), g.GetTotalAmountBorrowed(g.GetGENID(Borrower)) + Quantity);
String strBLOBFilePath = s.SavePath;//Modify this path as needed.
//Read jpg into file stream, and from there into Byte array.
FileStream fsBLOBFile = new FileStream(strBLOBFilePath, FileMode.Open, FileAccess.Read);
Byte[] bytBLOBData = new Byte[fsBLOBFile.Length];
fsBLOBFile.Read(bytBLOBData, 0, bytBLOBData.Length);
fsBLOBFile.Close();
db.sp_NewBorrowBarcodeInsert(TransactionID, bytBLOBData, s.SavePath);
}
private void materialRaisedButton1_Click(object sender, EventArgs e)
{
t.NewTransaction(DateTime.Now, Action, AdminID);
foreach (DataGridViewRow row in dgvReservation.Rows)
{
t.NewEquipmentReservation(TransactionID, ReserveeID, Convert.ToInt32(row.Cells[0].Value), ReservationDate, Convert.ToInt32(row.Cells[2].Value), false);
t.BorrowableEditQuantity(Convert.ToInt32(row.Cells[0].Value), g.GetEquipmentBorrowableQuantity(Convert.ToInt32(row.Cells[0].Value)) + Convert.ToInt32(row.Cells[2].Value));
}
s.GenerateBarcode(TransactionID.ToString());
String strBLOBFilePath = s.SavePath;//Modify this path as needed.
//Read jpg into file stream, and from there into Byte array.
FileStream fsBLOBFile = new FileStream(strBLOBFilePath, FileMode.Open, FileAccess.Read);
Byte[] bytBLOBData = new Byte[fsBLOBFile.Length];
fsBLOBFile.Read(bytBLOBData, 0, bytBLOBData.Length);
fsBLOBFile.Close();
db.sp_NewBorrowBarcodeInsert(TransactionID, bytBLOBData, s.SavePath);
MetroMessageBox.Show(this, "Transaction Complete", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmReservationSlip f = new frmReservationSlip(TransactionID, AdminID, ReserveeID, ReservationDate);
f.ShowDialog();
this.Close();
}
/*Event handler for confirm button to store the input values into variables and display them*/
private void buttonConfirm_Click(object sender, EventArgs e)
{
/*Statement to handle exception and prevent the programme from crashing*/
try
{
/*Converting string datatype in double datatype and storing it in variable */
TransactionID = double.Parse(textBoxTransactionId.Text);
/*storing the value of textboxes in variable od string datatype*/
FirstName = textBoxFirstName.Text;
LastName = textBoxLastName.Text;
/*Converting string datatype in decimal datatypeand storing it in variable*/
TelephoneNumber = decimal.Parse(textBoxTelephoneNumber.Text);
EmailAddress = textBoxEmailAddress.Text;
/*Validating all the input values so that user enter valid values at every time*/
if ((System.Text.RegularExpressions.Regex.IsMatch((textBoxFirstName.Text), @"^[a-zA-Z]+$")) && (System.Text.RegularExpressions.Regex.IsMatch((textBoxLastName.Text), @"^[a-zA-Z]+$")) && (System.Text.RegularExpressions.Regex.IsMatch((textBoxTelephoneNumber.Text), @"^[0-9]+$")) && (ValidationEmailId(EmailAddress)))
{
/*Storing the value in labels*/
labelFirstName.Text = FirstName;
labelLastName.Text = LastName;
labelTelephoneNumber.Text = TelephoneNumber.ToString();
labelEmailAddress.Text = EmailAddress;
labelTransactionId.Text = TransactionID.ToString();
groupBoxFullClientDetails.Visible = true;
groupBoxIntrestRate.Visible = false;
groupBoxDetails.Visible = false;
groupBoxInvest.Visible = false;
panelSearch.Visible = false;
/*Using substring on strings to get the part of the string and then storing in a avariable*/
Term = ClientInfo.Substring(4, 2);
labelTermChoosen.Text = Term;
RateofIntrest = ClientInfo.Substring(30, 8);
/*Converting the variable in string data type and storing in labesl*/
labelIntrestRate.Text = RateofIntrest.ToString();
FinalBalance = ClientInfo.Substring(ClientInfo.IndexOf("=") + 2);
labelBalanceAmt.Text = FinalBalance;
labelPrinipalAmount.Text = amount.ToString();
MessageBox.Show("Press confirm Button for final confirmation else press cancel");
}
else
{
groupBoxDetails.Visible = true;
groupBoxFullClientDetails.Visible = false;
MessageBox.Show("Please enter alphabets for names");
}
}
/*Statement will catch any exception thrown by try statement*/
catch (Exception)
{
MessageBox.Show("Enter all valid values");
}
}
private void TransactionDetails_Load(object sender, EventArgs e)
{
lblProcessedBY.Text = AdminFullname;
lblTransactionDate.Text = TransactionDate.ToShortDateString();
lblTransactionID.Text = TransactionID.ToString();
lblTransactionType.Text = TransactionType;
if (TransactionType == "Borrowed an Equipment")
{
dgvTransactionDetails.DataSource = db.sp_ViewBorrowedEquipment(TransactionID);
}
}
private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
if (e.Error != null)
{
MetroMessageBox.Show(this, "Error Occured", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MetroMessageBox.Show(this, "Transaction Complete", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmDeployment d = new frmDeployment(lblProcessedBy.Text, lblTeacher.Text, Convert.ToDateTime(lblTransactionDate.Text), DeploymentDate, Room, TransactionID.ToString());
d.ShowDialog();
this.Dispose();
}
}
protected override string GenerateBankFileDetail(GenericBankFileDetail bankFileDetail)
{
EBankList banklist = new EBankList();
banklist.BankCode = bankFileDetail.BankCode;
if (EBankList.db.select(dbConn, banklist))
{
BankName = banklist.BankName;
}
string[] bankFileDetailRecord = new string[45];
bankFileDetailRecord[0] = "TRN";
bankFileDetailRecord[1] = "PAYROL"; // PAYROL - Hong Kong Payroll ACH Payment (AUTOPAY)
//bankFileDetailRecord[2] = "omit";.Substring(0, 3)
bankFileDetailRecord[4] = "6055"; // 6055 - BOA Hong Kong, HK
bankFileDetailRecord[5] = AccountNo.PadRight(31).Substring(0, 31).TrimEnd();
//bankFileDetailRecord[6] = "";//bankFileDetail.BranchCode;//.Substring(0, 9);
bankFileDetailRecord[7] = "HKD";
bankFileDetailRecord[8] = "PAY"; // PAY - Payment
bankFileDetailRecord[9] = "D"; // D - Payment Only
//bankFileDetailRecord[10] = FIELD_POSTINGINDICATOR;//.Substring(0, 1);
//bankFileDetailRecord[11] = "";//.Substring(0, 16);
//bankFileDetailRecord[12] = FIELD_PRIORITYINDICATOR;//.Substring(0, 1);
bankFileDetailRecord[13] = AppUtils.ServerDateTime().ToString("MMddHHmmss") + TransactionID.ToString("000000");
//bankFileDetailRecord[14] = "";//.Substring(0, 2);
bankFileDetailRecord[15] = AccountHolderName.ToUpper().PadRight(35).Substring(0, 35).Trim();
//bankFileDetailRecord[16] = "";.Substring(0, 15);
bankFileDetailRecord[17] = PostalAddress1.PadRight(35).Substring(0, 35).Trim();
bankFileDetailRecord[18] = PostalAddress2.PadRight(35).Substring(0, 35).Trim();
bankFileDetailRecord[19] = PostalCityName.PadRight(30).Substring(0, 30).Trim();
bankFileDetailRecord[22] = "HK";
bankFileDetailRecord[23] = bankFileDetail.EmpName.ToUpper().PadRight(70).Substring(0, 70).Trim();
//bankFileDetailRecord[25] = "ADDRESS LINE 1"+" " ";
//bankFileDetailRecord[27] = "HONG KONG";
bankFileDetailRecord[30] = "HK";
bankFileDetailRecord[31] = bankFileDetail.ValueDate.ToString("yyyyMMdd");
bankFileDetailRecord[33] = "HKD";
bankFileDetailRecord[34] = bankFileDetail.Amount.ToString("0.00");
bankFileDetailRecord[37] = BankName.ToUpper().PadRight(33).Substring(0, 33).Trim();
bankFileDetailRecord[39] = bankFileDetail.BankCode.PadRight(3).Substring(0, 3) + bankFileDetail.BranchCode.PadRight(3).Substring(0, 3);
bankFileDetailRecord[41] = bankFileDetail.AccountNo.PadRight(9).Substring(0, 9).Trim();
bankFileDetailRecord[43] = "HONG KONG";
bankFileDetailRecord[44] = "HK";
string bankFileDetailData = "\"" + String.Join(FIELD_DELIMITER, bankFileDetailRecord) + "\"";
bankFileDetailData = bankFileDetailData.Replace("\"\"", string.Empty);
//if (bankFileDetailData.Length > 715)
// throw (new Exception("Incorrect Detail Length of Payment for " + bankFileDetail.EmpBankAccountHolderName + ":" + bankFileDetailData.Length));
return(bankFileDetailData);
}
