private void btnBrowseBorrower_Click(object sender, EventArgs e)
{
BrowseData.frmSearch oFrm = new BrowseData.frmSearch();
oFrm.oFilterFindOption = ePublicVariable.eVariable.FIND_OPTION.BORROWER;
oFrm.StartPosition = FormStartPosition.CenterScreen;
oFrm.ShowDialog();
oBorrower = new DataAccess.Borrower();
oMBorrower = new Model.Borrower();
oMBorrower.PERSON_ID = oFrm.oMBorrower.PERSON_ID;
if (!oBorrower.HasUnsettledBook(oMBorrower))
{
txtBorrowerID.Text = oFrm.oMBorrower.PERSON_ID;
txtFname.Text = oFrm.oMBorrower.FIRST_NAME;
txtMname.Text = oFrm.oMBorrower.MIDDLE_NAME;
txtLname.Text = oFrm.oMBorrower.LAST_NAME;
txtBirthDate.Text = oFrm.oMBorrower.DOB;
txtAge.Text = oFrm.oMBorrower.AGE;
txtContactNo.Text = oFrm.oMBorrower.CONTACT_NO;
txtAddress.Text = oFrm.oMBorrower.ADDRESS;
}
else
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.BORROWER_HAS_CURRENTLY_HAVE_ACTIVE_TRANSACTION.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
}
}
private void btnBrowseI_Click(object sender, EventArgs e)
{
try
{
if (cboImport.SelectedText == "BORROWER" || cboImport.Text == "BORROWER")
{
OpenFileDialog oDiaglog = new OpenFileDialog
{
InitialDirectory = @"D:\",
Title = "Browse CSV Files",
CheckFileExists = true,
CheckPathExists = true,
DefaultExt = "csv",
Filter = "CSV files (*.CSV)|*.CSV",
FilterIndex = 2,
RestoreDirectory = true,
ReadOnlyChecked = true,
ShowReadOnly = true
};
if (oDiaglog.ShowDialog() == DialogResult.OK)
{
txtImportPath.Text = oDiaglog.FileName;
oBorrower = new DataAccess.Borrower();
lstBorrower = oBorrower.GetCSVData(txtImportPath.Text);
dgImport.DataSource = lstBorrower;
}
}
if (txtImportPath.Text.Trim() != String.Empty)
{
foreach (DataGridViewColumn col in dgImport.Columns)
{
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
for (int i = 0; i < dgImport.RowCount; i++)
{
for (int j = 0; j < dgImport.ColumnCount; j++)
{
if (dgImport.Rows[i].Cells[j].Value != null)
{
if (dgImport.Rows[i].Cells[j].Value.ToString().Trim() == string.Empty)
{
dgImport.Columns[j].Visible = false;
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btnCheck_Click(object sender, EventArgs e)
{
oBorrower = new DataAccess.Borrower();
if (oBorrower.HasUnsettledBook(txtBorrowerID.Text))
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.BORROWER_HAS_CURRENTLY_HAVE_ACTIVE_TRANSACTION.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
txtBorrowerID.Text = string.Empty;
lblMemberStatus.Text = "";
return;
}
if (oBorrower.IsCustomerMember(txtBorrowerID.Text.Trim()))
{
lblMemberStatus.Text = "VALID";
btnCheck.Enabled = false;
txtBorrowerID.Enabled = false;
}
else
{
lblMemberStatus.Text = "INVALID";
}
}
private void btnButton_Click(object sender, EventArgs e)
{
if (btnButton.Text.Trim() == "IMPORT")
{
if (txtImportPath.Text.Trim() == String.Empty)
{
MessageBox.Show("Please select file to import");
return;
}
#region Import
try
{
if (cboImport.SelectedText == "BORROWER" || cboImport.Text == "BORROWER")
{
if (dgImport.Rows.Count > 0)
{
foreach (var iData in lstBorrower)
{
oBorrower = new DataAccess.Borrower();
if (!oBorrower.IsRecordExists(iData))
{
oBorrower.InsertBorrower(iData);
}
}
oFrmMsgBox = new Forms.frmMessageBox(eVariable.TransactionMessage.RECORD_HAS_BEEN_SUCESSFULLY_SAVED.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
}
}
}
catch (Exception ex)
{
}
#endregion
}
else
{
if (txtExportPath.Text.Trim() == string.Empty)
{
MessageBox.Show(eVariable.TransactionMessage.PLEASE_SELECT_DISTINATION_PATH_TO_SAVE_THE_FILE.ToString().Replace("_", " "));
return;
}
if (dgExport.Rows.Count == 0)
{
MessageBox.Show(eVariable.TransactionMessage.PLEASE_POPULATE_A_RECORD_FIRST.ToString().Replace("_", " "));
return;
}
#region Export
ExtractData();
#endregion
}
}
private void AutoFillBorrower()
{
oBorrower = new DataAccess.Borrower();
foreach (DataRow row in oBorrower.GetRecords(eVariable.FIND_BORROWER.BORROWER_ID, oMBorrower.PERSON_ID).Rows)
{
txtBorrowerID.Text = row[0].ToString();
txtFulllname.Text = row[1].ToString() + " " + row[2].ToString() + " " + row[3].ToString();
}
AutoFillBook();
}
private void GenerateBorrowerNo()
{
int iBorrowerNo = 0;
oBorrower = new DataAccess.Borrower();
iBorrowerNo = oBorrower.GetBorrowerNo() + 1;
if (eVariable.m_ActionType == eVariable.ACTION_TYPE.ADD)
{
txtBorrowerID.Text = "BWR-" + (iBorrowerNo).ToString("0000#");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
oMBorrower = new Model.Borrower();
oBorrower = new DataAccess.Borrower();
oCommonFunction = new CommonFunction.CommonFunction();
oImageFunction = new CommonFunction.CommonFunction();
if (eVariable.IsFieldEmpty(pnlMain))
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.ALL_FIELDS_ARE_REQUIRED.ToString().Replace("_", " "));
oFrmMsgBox.ShowDialog();
return;
}
oMBorrower.PERSON_ID = txtBorrowerID.Text;
oMBorrower.FIRST_NAME = txtFname.Text;
oMBorrower.MIDDLE_NAME = txtMname.Text;
oMBorrower.LAST_NAME = txtLname.Text;
oMBorrower.DOB = dtDOB.Value.ToString("yyyy-MM-dd");
oMBorrower.AGE = txtAge.Text;
oMBorrower.CONTACT_NO = txtContactNo.Text;
oMBorrower.ADDRESS = txtAddress.Text;
if (pImage.Image != null)
{
oMBorrower.PROFILE_PIC = oCommonFunction.CompressString(oImageFunction.ImageToBaseString(pImage.Image, ImageFormat.Png));
}
if (eVariable.m_ActionType == eVariable.ACTION_TYPE.EDIT)
{
oMBorrower.MODIFIED_BY = eVariable.sUsername;
oMBorrower.MODIFIED_DATE = DateTime.Now.ToString("yyyy-MM-dd");
oBorrower.UpdateBorrower(oMBorrower);
}
else
{
oMBorrower.ADDED_BY = eVariable.sUsername;
oMBorrower.ADDED_DATE = DateTime.Now.ToString("yyyy-MM-dd");
oBorrower.InsertBorrower(oMBorrower);
}
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.RECORD_HAS_BEEN_SUCESSFULLY_SAVED.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
oFrmBorrowerLst.LoadBorrower();
eVariable.ClearText(pnlMain);
ResetFields();
Close();
}
public void LoadBorrower()
{
try
{
oBorrower = new DataAccess.Borrower();
dgExport.Rows.Clear();
oFilterBorrower = ePublicVariable.eVariable.FIND_BORROWER.FIRST_NAME;
BorrowerStructure();
foreach (DataRow row in oBorrower.GetRecords(oFilterBorrower, "").Rows)
{
dgExport.Rows.Add(row["BORROWER_ID"], row["FIRST_NAME"], row["MIDDLE_NAME"], row["LAST_NAME"], row["DOB"], row["AGE"], row["CONTACT_NO"], row["ADDRESS"], row["STATUS"], row["PROFILE_PIC"]);
}
}
catch (Exception ex)
{
}
}
public void LoadBorrower()
{
try
{
oBorrower = new DataAccess.Borrower();
dgDetails.Rows.Clear();
eVariable.DisableGridColumnSort(dgDetails);
foreach (DataRow row in oBorrower.GetRecords(oFilterBorrower, tbxSearch.Text).Rows)
{
dgDetails.Rows.Add(row["BORROWER_ID"], row["FIRST_NAME"], row["MIDDLE_NAME"], row["LAST_NAME"], row["DOB"], row["AGE"], row["CONTACT_NO"], row["ADDRESS"], row["STATUS"], row["PROFILE_PIC"]);
}
lblTotalRecords.Text = dgDetails.Rows.Count.ToString();
}
catch (Exception ex)
{
}
}
public void GetBorrowerRequest()
{
oBorrower = new DataAccess.Borrower();
dgDetails.DataSource = oBorrower.GetBorrowerTransaction(ePublicVariable.eVariable.FIND_BOOK.BOOK_REQUESTED, "");
foreach (DataGridViewColumn col in dgDetails.Columns)
{
col.Width = 115;
//col.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
if (col.Name == "ADDRESS")
{
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
ChangeCellGridColor();
lblTotalRecord.Text = dgDetails.Rows.Count.ToString();
TranType = eVariable.FIND_BOOK.BOOK_REQUESTED;
}
private void AutoFillBorrower()
{
oBorrower = new DataAccess.Borrower();
foreach (DataRow row in oBorrower.GetBorrowerTransaction(eVariable.FIND_BOOK.BOOK_REQUESTED, eVariable.sBorrowerID).Rows)
{
txtBorrowerID.Text = row[0].ToString();
txtFname.Text = row[1].ToString();
txtMname.Text = row[2].ToString();
txtLname.Text = row[3].ToString();
txtBirthDate.Text = row[4].ToString();
txtAge.Text = row[5].ToString();
txtContactNo.Text = row[6].ToString();
txtAddress.Text = row[7].ToString();
eVariable.sBorrowerID = txtBorrowerID.Text;
eVariable.FirstName = txtFname.Text;
eVariable.MiddleName = txtMname.Text;
eVariable.LastName = txtLname.Text;
}
AutoFillBook();
}
void LoadBorrowerRequest()
{
oBorrower = new DataAccess.Borrower();
eVariable.DisableGridColumnSort(dgBorrower);
dgBorrower.DataSource = oBorrower.GetBorrowerTransaction(ePublicVariable.eVariable.FIND_BOOK.BOOK_BORROWED, "");
foreach (DataGridViewColumn col in dgBorrower.Columns)
{
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
if (col.Name == "ADDRESS")
{
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
if (col.Name == "ADDED_DATE")
{
col.Visible = false;
}
}
ChangeCellGridColor();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
int iDaysCount = 0;
int iBookCount = 0;
try
{
if (dgBorrowedBooks.Rows.Count == 0)
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.PLEASE_SELECT_A_RECORD.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
foreach (DataGridViewRow row in dgBorrowedBooks.Rows)
{
iBookCount += Convert.ToInt32(row.Cells[9].Value);
}
if (oMTransactionList.Count != iBookCount || oMTransactionList.Count == 0)
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.PLEASE_ENTER_BOOK_NUMBER.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
if (iGridControl.Visible == true)
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.PLEASE_CLOSE_THE_ISBN_PANEL.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
foreach (var oData in oMTransactionList)
{
iDaysCount = Convert.ToInt32(oData.TOTAL_DAYS);
if (iBookCount > Convert.ToInt32(lblMaxBook.Text))
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.TOTAL_BOOK_COUNT_ALREADY_EXCEED_LIMIT.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
if (iDaysCount > Convert.ToInt32(lblMaxDays.Text))
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.TOTAL_DAY_COUNT_ALREADY_EXCEED_LIMIT.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
}
oBorrower = new DataAccess.Borrower();
if (dgBorrowedBooks.Rows.Count > 0)
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.ARE_YOU_SURE_YOU_WANT_TO_PROCEED_TO_THE_TRANSACTION.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.QUERY;
oFrmMsgBox.ShowDialog();
if (oFrmMsgBox.sAnswer == "YES")
{
foreach (Model.Transaction oData in oMTransactionList)
{
oMTransaction = new Model.Transaction();
oBook = new DataAccess.Book();
oMTransaction.BOOK_ID = oData.BOOK_ID;
oMTransaction.PERSON_ID = txtBorrowerID.Text;
oMTransaction.BOOK_NO = oData.BOOK_NO;
oMTransaction.TITLE = oData.TITLE;
oMTransaction.SUBJECT = oData.SUBJECT;
oMTransaction.CATEGORY = oData.CATEGORY;
oMTransaction.AUTHOR = oData.AUTHOR;
oMTransaction.PUBLISH_DATE = oData.PUBLISH_DATE;
oMTransaction.ISBN_NUMBER = oData.ISBN_NUMBER;
oMTransaction.LOCATION = oData.LOCATION;
oMTransaction.BOOK_PRICE = oData.BOOK_PRICE;
oMTransaction.RENT_PRICE = oData.RENT_PRICE;
oMTransaction.DUE_INTEREST = oData.DUE_INTEREST;
oMTransaction.LD_INTEREST = oData.LD_INTEREST;
oMTransaction.TOTAL_QTY = oData.TOTAL_QTY;
oMTransaction.TOTAL_DAYS = oData.TOTAL_DAYS;
oMTransaction.ADDED_DATE = DateTime.Now.ToString("yyyy-MM-dd");
oMTransaction.ADDED_BY = txtBorrowerID.Text;
oMTransaction.STATUS = "REQUEST";
oBook.RequestBook(oMTransaction);
}
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.TRANSACTION_HAS_BEEN_SUCESSFULLY_SAVE.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.QUERY;
oFrmMsgBox.ShowDialog();
LoadRecords();
clearText();
}
}
}
catch (Exception ex)
{ }
}
