public int borrw_book(int mem, int book, string acc_date, string ret_date)
{
int ret;
if (alredy_borrowed(book))
{
MessageBox.Show("BOOK Alredy Borrowed", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
ret = -1;
}
else if (pending_yes(mem))
{
MessageBox.Show("User alredy Borrowed 2 Books", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
ret = -1;
}
else
{
string query = "INSERT INTO tbl_borrow(mem_id,book_id,borrow_date,ret_date,pending)VALUES( " +
mem + ", " + book + ", '" + acc_date + "', '" + ret_date + "','YES');" +
"UPDATE tbl_Books SET bkstatus ='Unavailable' WHERE book_ID = " + book + ";";
dt = new Classes.Database();
ret = dt.updateDatabase(query);
}
return(ret);
}
public int delete_member(int mem)
{
try
{
string query = "DELETE FROM tbl_Member WHERE mem_ID = " + mem;
dt = new Classes.Database();
int ret = dt.updateDatabase(query);
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
public int delete_book(int bkID)
{
try
{
string query = "DELETE FROM tbl_Books WHERE book_ID = " + bkID;
// SQL querry to delete the book record
dt = new Classes.Database();
int ret = dt.updateDatabase(query);
return(ret);
// returing the result of the query 1 == success ,other unsuccesfull
}
catch (Exception ex)
{
throw ex;
}
}
public int addMember(string FName, string LName, string line1, string city, string contact)
{
try
{
string query = "INSERT INTO tbl_Member(memFirstName,memLastName,memaddressLine1,memaddressLine2,memcontactNumber) VALUES(' " +
FName + "' , '" + LName + "' , '" + line1 + "' , '" + city + "' , '" + contact + "' )";
dt = new Classes.Database();
Console.WriteLine(query);
int ret = dt.updateDatabase(query);
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
public int update_member(string FName, string LName, string line1, string city, string contact, int memid)
{
try
{
string query = "UPDATE tbl_Member SET memFirstName = '" + FName +
"', memLastName = '" + LName + "' ,memaddressLine1 ='" + line1 + "', memaddressLine2 = '" + city
+ "', memcontactNumber = '" + contact + "' WHERE mem_ID =" + memid;
dt = new Classes.Database();
Console.WriteLine(query);
int ret = dt.updateDatabase(query);
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
public int addPayment(string p_type, float p_amt, string p_details, int libID, int memID, string curr_time)
{
try
{
dt = new Classes.Database();
string query = "INSERT INTO tbl_Payment (payType, paymentAmount, paymentDetails,lib_id,mem_id,date_time) VALUES('"
+ p_type + "' , " + p_amt + " , '" + p_details + "' , " + libID + " , " + memID + ", '" + curr_time + "' )";
MessageBox.Show(query);
int ret = dt.updateDatabase(query);
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
public int addLibrarian(string FName, string LName, string line1, string city, string contact,
string uername, string password, string libtype)
{
try
{
string query = "INSERT INTO tbl_Librarian(libFirstName,libLastName,addressLine1,addressLine2,contactNumber,username,libpassword,libtype)VALUES(" + "'" + FName + "'" + ","
+ "'" + LName + "'" + "," + "'" + line1 + "'" + ","
+ "'" + city + "'" + "," + "'" + contact + "'" + "," +
"'" + uername + "'" + "," + "'" + password + "'" + "," +
"'" + libtype + "'" + ")";
Classes.Database db = new Classes.Database();
int ret = db.updateDatabase(query);
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
public int updateBook(int bkID, string BookName, string Auther, string Genre, float Price, float FineDay,
string Location, string Status)
{
try
{
// Db Connection
dt = new Classes.Database();
string query = "UPDATE tbl_Books SET book_name ='" + BookName + "', auther = '" + Auther + "',genre ='" +
Genre + "', price = " + Price + " ,fine_day =" + FineDay + ",bklocation = '" + Location + "', bkstatus ='" + Status
+ "' WHERE book_ID = " + bkID;
// SQL Auerry to update Book Details
int ret = dt.updateDatabase(query); // runnig the SQL query
return(ret); // returing the result of the query 1 == success ,other unsuccesfull
}
catch (Exception ex)
{
throw ex;
}
}
// Real Function
public int addBook(string BookName, string Auther, string Genre, float Price, float FineDay,
string Location, string Status)
{
try
{
// Db Connection
dt = new Classes.Database();
string query = "INSERT INTO tbl_Books(book_name,auther,genre,price,fine_day,bklocation,bkstatus)VALUES(" + "'" + BookName +
"'" + "," + "'" + Auther + "'" + "," + "'" + Genre + "'" + "," +
Price + "," + FineDay + "," +
"'" + Location + "'" + "," + "'" + Status + "'" + ")";
// SQL Auerry to insert Book Details
int ret = dt.updateDatabase(query); // runnig the SQL query
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
public int ret_book(int mem, int book, string date, float fine)
{
try
{
// Db Connection
string query = "UPDATE tbl_Books SET bkstatus ='Available' WHERE book_ID = " + book + "; " +
"UPDATE tbl_borrow SET pending ='NO' ,fine = " + fine +
" WHERE book_id = " + book + "AND mem_id =" + mem + ";";
DateTime today = DateTime.Today;
dt = new Classes.Database();
int ret = dt.updateDatabase(query);
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
