/// <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 } }