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()); }