/// <summary>
/// Add the new borrower entry in Database
/// </summary>
/// <param name="fname"></param>
/// <param name="lname"></param>
/// <param name="address"></param>
/// <param name="phone"></param>
/// <returns></returns>
public int AddNewBorrwoer(string fname, string lname, string address, string phone, string city, string state)
{
tblBORROWER newBorrowerEntry;
int cardNumber;
try
{
using (LibraryEntities entity = new LibraryEntities())
{
newBorrowerEntry = new tblBORROWER();
newBorrowerEntry.Fname = fname.Trim();
newBorrowerEntry.Lname = lname.Trim();
newBorrowerEntry.Phone = phone.Trim();
newBorrowerEntry.Address = address.Trim();
newBorrowerEntry.State = state.Trim();
newBorrowerEntry.City = city.Trim();
entity.AddTotblBORROWERs(newBorrowerEntry);
entity.SaveChanges();
cardNumber = (from newBorrower in entity.tblBORROWERs
where newBorrower.Fname == fname.Trim() &&
newBorrower.Lname == lname.Trim() && newBorrower.Address == address
select newBorrower.Card_no).FirstOrDefault();
}
return(cardNumber);
}
catch (Exception e)
{
cardNumber = -1;
return(cardNumber);
// Exception In Entity
}
}
