public void UpdateBookReturn(Entities.booktran btTran, int TransID)
{
Entities.LibEntities dbCtx = new Entities.LibEntities();
Entities.booktran bkUpdate = dbCtx.booktrans.First(b => b.TRANSID == TransID);
bkUpdate.TRANSID = btTran.TRANSID;
bkUpdate.ReturnDate = btTran.ReturnDate;
dbCtx.SaveChanges();
}
public void UpdateBookTrans(Entities.booktran btTran, int TransID)
{
Entities.LibEntities dbCtx = new Entities.LibEntities();
Entities.booktran bkUpdate = dbCtx.booktrans.First(b => b.TRANSID == TransID);
if (String.IsNullOrEmpty(btTran.MemberID))
{
bkUpdate.TRANSID = btTran.TRANSID;
bkUpdate.ReturnDate = btTran.ReturnDate;
//bt.LendRate = Int32.Parse(ds.Rows[0]["LendRate"].ToString());
bkUpdate.Fine = btTran.Fine;
bkUpdate.LibBal = btTran.LibBal;
bkUpdate.MemBal = btTran.MemBal;
}
else
{
BaseRepository.CopyPropertyValues(btTran, bkUpdate);
}
dbCtx.SaveChanges();
}
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();
}
}
}
}
public void InsertBookTrans(Entities.booktran tranObj)
{
Entities.LibEntities dbCtx = new Entities.LibEntities();
dbCtx.booktrans.Add(tranObj);
dbCtx.SaveChanges();
}
private void btnLoan_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? strBalance = 0;
bool isMulLoan = false;
if (gridTrans.RowCount > 0)
{
for (int i = 0; i < gridTrans.RowCount; i++)
{
if (gridTrans[0, i].EditedFormattedValue.ToString().Equals("True"))
{
isMulLoan = true;
bt.BookID = gridTrans["BookID", i].Value.ToString();
if (arBookid.Length == 0)
{
strTemp = gridTrans["MemberID", i].Value.ToString();
}
else
{
if (strTemp != gridTrans["MemberID", i].Value.ToString())
{
MessageBox.Show("Loan processing can be done only for one member at a time");
return;
}
}
bt.MemberID = gridTrans["MemberID", i].Value.ToString();
if (bt.MemberID.Equals(""))
{
MessageBox.Show("MemberID cannot be empty");
return;
}
if (Int32.Parse(memRep.GetMemberIDDetails(bt.MemberID).Rows[0]["Status"].ToString()) < 1)
{
if (MessageBox.Show("Do you want to continue?", "Inactive Member", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
bt.LendDate = DateTime.Parse(gridTrans["LendDate", i].Value.ToString());
bt.DueDate = DateTime.Parse(gridTrans["DueDate", i].Value.ToString());
if (dateTransReturn.Checked)
{
MessageBox.Show("You cannot specify Return date for Loan Processing");
return;
}
if (transRep.GetLoanDetailsBooksMem(bt.BookID, bt.MemberID, true).Rows.Count > 0)
{
MessageBox.Show("Bookid " + bt.BookID + " already loaned out");
return;
}
if (transRep.GetLoanDetailsBooksMem(bt.BookID, bt.MemberID).Rows.Count > 0)
{
if (MessageBox.Show("Do you want to continue?", bt.BookID + " already read by member", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
bt.LendRate = Int32.Parse(gridTrans["LendRate", i].Value.ToString());
bt.Fine = Int32.Parse(gridTrans["Fine", i].Value.ToString());
bt.LibBal = Int32.Parse(gridTrans["LibBal", i].Value.ToString());
bt.MemBal = Int32.Parse(gridTrans["MemBal", i].Value.ToString());
bt.RenewalDays = Int32.Parse(gridTrans["RenewalDays", i].Value.ToString());
if (!bt.Fine.Equals(""))
{
strFine = bt.Fine + strFine;
}
if (!bt.LendRate.Equals(""))
{
strLendRate = bt.LendRate + strLendRate;
}
if (!bt.MemBal.Equals(""))
{
strBalance = bt.MemBal + strBalance;
}
arBookid.Append(bt.BookID + ",");
//updateLoanReturn(bt, false, false);
}
}
if (isMulLoan)
{
if (arBookid.Length > 0)
{
arBookid.Remove(arBookid.Length - 1, 1);
}
if (MessageBox.Show("Books Loaned:" + arBookid.ToString() + "\nMemberID:" + bt.MemberID + "\nLend Rate:" + strLendRate + "\nFine:" + strFine + "\nBalance:" + strBalance, "Confirm Transaction", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
for (int i = 0; i < gridTrans.RowCount; i++)
{
if (gridTrans[0, i].EditedFormattedValue.ToString().Equals("True"))
{
bt.BookID = gridTrans["BookID", i].Value.ToString();
bt.MemberID = gridTrans["MemberID", i].Value.ToString();
bt.LendDate = DateTime.Parse(gridTrans["LendDate", i].Value.ToString());
bt.DueDate = DateTime.Parse(gridTrans["DueDate", i].Value.ToString());
//bt.ReturnDate = DateTime.Parse(dateTransReturn.Text).ToShortDateString();
bt.CreatedDate = DateTime.Now;
bt.LendRate = Int32.Parse(gridTrans["LendRate", i].Value.ToString());
bt.Fine = Int32.Parse(gridTrans["Fine", i].Value.ToString());
bt.LibBal = Int32.Parse(gridTrans["LibBal", i].Value.ToString());
bt.MemBal = Int32.Parse(gridTrans["MemBal", i].Value.ToString());
bt.RenewalDays = Int32.Parse(gridTrans["RenewalDays", i].Value.ToString());
transRep.InsertBookTrans(bt);
}
}
gridTrans.DataSource = transRep.GetTransDetails();
gridTrans.Refresh();
//bt.LendDate = "";
//bt.DueDate = "";
//bt.ReturnDate = "";
//LibBookTrans lbt = new LibBookTrans();
//lbt.displayTrans(bt, gridTrans);
}
}
//else
//{
// if (dateTransReturn.Checked)
// {
// MessageBox.Show("You cannot specify Return date for Loan Processing");
// return;
// }
// if (transRep.GetLoanDetailsBooksMem(bt.BookID, bt.MemberID, true).Rows.Count > 0)
// {
// MessageBox.Show("Bookid " + txtTransBookid.Text + " already loaned out");
// return;
// }
// if (MessageBox.Show("Books Loaned:" + txtTransBookid.Text + "\nMemberID:" + txtTransMemId.Text + "\nLend Rate:" + txtTransLendRate.Text + "\nFine:" + txtTransFine.Text + "\nBalance:" + txtMemBal.Text + "\nRenewal Days:" + txtRenewal.Text, "Confirm Transaction", MessageBoxButtons.YesNo) == DialogResult.Yes)
// {
// bt.BookID = txtTransBookid.Text.ToString();
// bt.MemberID = txtTransMemId.Text;
// bt.LendDate = DateTime.Parse(dateTransLoan.Text);
// bt.DueDate = DateTime.Parse(dateTransDue.Text);
// 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.MemBal=txt
// bt.RenewalDays = Int32.Parse(txtRenewal.Text);
// transRep.InsertBookTrans(bt);
// gridTrans.DataSource = transRep.GetTransLoanDetails(bt.MemberID);
// //updateLoanReturn(bt, false, true);
// //bt.LendDate = "";
// //bt.DueDate = "";
// //bt.ReturnDate = "";
// //LibBookTrans lbt = new LibBookTrans();
// //lbt.displayTrans(bt, gridTrans);
// }
//}
}
}