public int SaveRecieveBookInfo(RecieveBook aRecieveBook)
{
string query = "INSERT INTO RecieveBook VALUES(@StudentId, @BookId, @DepartmentId, @RecieveDate, @LateFee)";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@StudentId", aRecieveBook.StudentId);
Command.Parameters.AddWithValue("@BookId", aRecieveBook.BookId);
Command.Parameters.AddWithValue("@DepartmentId", aRecieveBook.DepartmentId);
Command.Parameters.AddWithValue("@RecieveDate", aRecieveBook.RecieveDate);
Command.Parameters.AddWithValue("@LateFee", aRecieveBook.LateFee);
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
public int SaveRecieveBookInfo(RecieveBook aRecieveBook)
{
Assign aAssignBook = aAdminGateWay.AssignBookInformation(aRecieveBook.StudentId, aRecieveBook.BookId);
TimeSpan dif = aRecieveBook.RecieveDate - aAssignBook.IssueDate;
double nodays = dif.TotalDays;
if (nodays > 14)
{
int newDif = Convert.ToInt32(nodays - 14);
aRecieveBook.LateFee = newDif * 2;
}
else
{
aRecieveBook.LateFee = 0;
}
return(aAdminGateWay.SaveRecieveBookInfo(aRecieveBook));
}
public ActionResult RecieveBook(RecieveBook aRecieveBook, string student)
{
ViewBag.Departments = aBookManager.GetAllDepartment();
Student aStudent = aAdminManager.StudentInformation(student);
aRecieveBook.StudentId = aStudent.Id;
int rowAffect = aAdminManager.SaveRecieveBookInfo(aRecieveBook);
if (rowAffect > 0)
{
ViewBag.Message = "Successful";
}
else
{
ViewBag.Message = "Filed";
}
return(View());
}
