private void btnTransUpdate_Click(object sender, EventArgs e)
{
Entities.booktran bt = new booktran();
bt.BookID = txtTransBookid.Text;
bt.MemberID = txtTransMemId.Text;
bt.LendDate = DateTime.Parse(dateTransLoan.Text);
bt.DueDate = DateTime.Parse(dateTransDue.Text);
bt.ReturnDate = null;
bt.CreatedDate = DateTime.Now;
bt.LendRate = Int32.Parse(txtTransLendRate.Text);
bt.Fine = Int32.Parse(txtTransFine.Text);
bt.LibBal = Int32.Parse(txtLibBal.Text);
bt.MemBal = Int32.Parse(txtMemBal.Text);
bt.RenewalDays = Int32.Parse(txtRenewal.Text);
bt.TRANSID = Int32.Parse(lblTransId.Text);
if (dateTransReturn.Checked)
{
bt.ReturnDate = DateTime.Parse(dateTransReturn.Text);
}
transRep.UpdateBookTrans(bt, bt.TRANSID);
txtSearch_trans.Text = txtTransMemId.Text;
gridTrans.DataSource = transRep.GetTransDetails(txtTransMemId.Text);
}
private void btn_Ret_Trans_Click(object sender, EventArgs e)
{
Entities.booktran bt = new Entities.booktran();
StringBuilder arBookid = new StringBuilder();
String strTemp = "";
int? strFine = 0;
int? strLendRate = 0;
int? strMemBalance = 0; int?strLibBalance = 0;
bool isMulLoan = false;
DataTable ds = new DataTable();
if (gridTrans.RowCount > 0)
{
for (int i = 0; i < gridTrans.RowCount; i++)
{
if (gridTrans[0, i].EditedFormattedValue.ToString().Equals("True"))
{
isMulLoan = true;
ds = transRep.GetTransIDDetails(Int32.Parse(gridTrans["TransID", i].Value.ToString()));
bt.BookID = ds.Rows[0]["BookID"].ToString();
if (arBookid.Length == 0)
{
strTemp = ds.Rows[0]["MemberID"].ToString();
}
else
{
if (strTemp != ds.Rows[0]["MemberID"].ToString())
{
MessageBox.Show("Return processing can be done only for one member at a time");
return;
}
}
bt.MemberID = ds.Rows[0]["MemberID"].ToString();
if (bt.MemberID.Equals(""))
{
MessageBox.Show("MemberID cannot be empty");
return;
}
bt.LendDate = DateTime.Parse(ds.Rows[0]["LendDate"].ToString());
bt.DueDate = DateTime.Parse(ds.Rows[0]["DueDate"].ToString());
if (dateTransReturn.Checked)
{
bt.ReturnDate = DateTime.Parse(dateTransReturn.Text);
}
else
{
MessageBox.Show("Please specify a Return Date");
return;
}
bt.LendRate = Int32.Parse(ds.Rows[0]["LendRate"].ToString());
//DateTime countDate=DateTime.Today-DateTime.Parse(ds.Rows[0]["DueDate"].ToString());
//int suggFine = Int32.Parse((DateTime.Today - DateTime.Parse(ds.Rows[0]["DueDate"].ToString())).TotalDays.ToString());
//if (suggFine > 0)
//suggFine = Int32.Parse(((suggFine / 15) * bt.LendRate*0.75).ToString());
//bt.Fine = Int32.Parse(txtTransFine.Text);
bt.LibBal = Int32.Parse(txtLibBal.Text);
bt.MemBal = Int32.Parse(txtMemBal.Text);
//if (!bt.Fine.Equals(""))
//strFine = bt.Fine;// +strFine;
if (!bt.LendRate.Equals(""))
{
strLendRate = bt.LendRate + strLendRate;
}
if (!bt.MemBal.Equals(""))
{
strMemBalance = bt.MemBal; //+ strMemBalance;
}
if (!bt.LibBal.Equals(""))
{
strLibBalance = bt.LibBal; //+ strLibBalance;
}
//bt.LendRate = "";
//bt.Fine = "";
//bt.LibBal = "";
arBookid.Append(bt.BookID + ",");
//updateLoanReturn(bt, false, false);
}
}
if (isMulLoan)
{
if (arBookid.Length > 0)
{
arBookid.Remove(arBookid.Length - 1, 1);
}
if (MessageBox.Show("Books Returned:" + arBookid.ToString() + "\nMemberID:" + bt.MemberID + "\nLend Rate:" + strLendRate + "\nMem Bal:" + strMemBalance + "\nLib Bal:" + strLibBalance, "Confirm Transaction", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
for (int i = 0; i < gridTrans.RowCount; i++)
{
//int tempID = 0;
if (gridTrans[0, i].EditedFormattedValue.ToString().Equals("True"))
{
Entities.booktran btTran = new booktran();
btTran.TRANSID = Int32.Parse(gridTrans["TransID", i].Value.ToString());
btTran.ReturnDate = DateTime.Parse(dateTransReturn.Text);
//btTran.Fine = Int32.Parse(txtTransFine.Text);
//btTran.LibBal = Int32.Parse(txtLibBal.Text);
//btTran.MemBal = Int32.Parse(txtMemBal.Text);
transRep.UpdateBookReturn(btTran, Int32.Parse(gridTrans["TransID", i].Value.ToString()));
//tempID = i;
}
//if (tempID > 0)
//{
// Entities.booktran btTran = new booktran();
// btTran.TRANSID = Int32.Parse(gridTrans["TransID", tempID].Value.ToString());
// bt.CreatedDate = DateTime.Now;
// btTran.ReturnDate = DateTime.Parse(dateTransReturn.Text);
// btTran.Fine = Int32.Parse(txtTransFine.Text);
// btTran.LibBal = Int32.Parse(txtLibBal.Text);
// btTran.MemBal = Int32.Parse(txtMemBal.Text);
// transRep.UpdateBookTrans(btTran, Int32.Parse(gridTrans["TransID", tempID].Value.ToString()));
//}
}
gridTrans.DataSource = transRep.GetTransDetails();
gridTrans.Refresh();
}
}
}
}
