internal List <bookReserveDetails> getBookReservedDetailsFromStudentID(string student_ID)
{
bookReserveDetails bookReserveDetails = new bookReserveDetails();
List <bookReserveDetails> list = new List <bookReserveDetails>();
CommonFunctions cf = new CommonFunctions();
student_ID = "%" + student_ID + "%";
string sql = "";
SqlCommand cmd = new SqlCommand();
sql = "select BRD.studentID, BRD.bookCode, BD.bookTitle, BRD.reservedDate, BRD.releseBeforeDate From bookReserveDetails BRD, bookCodeDetails BCD,bookDetails BD where BRD.bookCode=BCD.bookCode AND BCD.bookID=BD.bookID AND BRD.studentID Like @student_ID";
SqlConnection con = new SqlConnection(db_connection_string);
cmd.Parameters.AddWithValue("@student_ID", student_ID);
cmd.CommandText = sql;
cmd.Connection = con;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
bookReserveDetails c = new bookReserveDetails();
c.bookCode = rdr["bookCode"].ToString();
c.bookTitle = rdr["bookTitle"].ToString();
c.reservedDate = DateTime.Parse(rdr["reservedDate"].ToString());
c.releseBeforeDate = DateTime.Parse(rdr["releseBeforeDate"].ToString());
c.reservedDateString = String.Format("{0:yyyy - MM - dd}", c.reservedDate);
c.releseBeforeDateString = String.Format("{0:yyyy - MM - dd}", c.releseBeforeDate);
c.studentID = rdr["studentID"].ToString();
list.Add(c);
}
con.Close();
return(list);
}
internal ReturnData deleteReservedBook(bookReserveDetails bookReserveDetails)
{
ReturnData rd = new ReturnData();
SqlConnection con = new SqlConnection(db_connection_string);
string sql = "";
sql = "Delete from bookReserveDetails where bookCode=@bookCode AND studentID=@studentID";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@bookCode", bookReserveDetails.bookCode);
cmd.Parameters.AddWithValue("@studentID", bookReserveDetails.studentID);
int count = 0;
con.Open();
try
{
count = (int)cmd.ExecuteNonQuery();
}
catch (Exception Ex)
{
rd.status = 0;
rd.message = Ex.Message;
}
con.Close();
if (count > 0)
{
rd.status = 1;
rd.message = "OK";
}
return(rd);
}
internal ReturnData validateIssueingBook(bookIssuingDetails bookIssuingDetails)
{
ReturnData rd = new ReturnData();
ReturnData isBookIDValid = new BookCodeDetails().validateBookID(bookIssuingDetails.bookID);
if (isBookIDValid.status == 1)
{
ReturnData isStudent = new studentDetails().validateStudentID(bookIssuingDetails.studentID);
if (isStudent.status == 1)
{
ReturnData isStudentEligibleToBorrowBook = studentBookRecodeCount(bookIssuingDetails.studentID);
if (isStudentEligibleToBorrowBook.status == 1)
{
ReturnData isBookAlreadyBorrowed = new BookCodeDetails().isBookAlreadyBorrowed(bookIssuingDetails.bookID);
if (isBookAlreadyBorrowed.status == 1)
{
ReturnData isBookNotReserved = new bookReserveDetails().isBookNotReserved(bookIssuingDetails.bookID);
if (isBookNotReserved.status == 1)
{
addBookIssuingDetails();
rd.message = "OK";
}
else
{
ReturnData isBookReservedByThisStudent = new bookReserveDetails().isBookReservedByThisStudent(bookIssuingDetails.studentID, bookIssuingDetails.bookID);
if (isBookReservedByThisStudent.status == 1)
{
addBookIssuingDetails();
rd.message = "OK";
}
else
{
rd.message = "This Book Already Reserved";
}
}
}
else
{
rd.message = "Check the BookCode.";
}
}
else
{
rd.message = "Student Has borrowed 2 Books";
}
}
else
{
rd.message = "Student ID is not Valid";
}
}
else
{
rd.message = "Book ID is not Valid";
}
return(rd);
}
internal ReturnData ReserveBook(bookReserveDetails bookReserveDetails)
{
ReturnData rd = new ReturnData();
SqlConnection con = new SqlConnection(db_connection_string);
string sql = "";
sql = "select bookCode from bookCodeDetails where bookID=@bookID and Borrowed='0' and Active='1' and reserved='0'";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@bookID", bookReserveDetails.bookID);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
bookCode = rdr["bookCode"].ToString();
rd = checkCountOfBooksReserved(bookReserveDetails.studentID);
if (rd.status > 0)
{
rd = changeReserveStatus(bookCode);
if (rd.status > 0)
{
rd = insertReserveDetails(bookReserveDetails.bookCode, bookReserveDetails.studentID);
}
}
}
else
{
rd.message = "No Book to Reserve";
rd.status = 0;
}
con.Close();
return(rd);
}