// DAO -- insert Rent public bool DAOinsertRent(Rent rent, ArrayList detaillist) { try { // connect GetConnection(); // insert rent SqlCommand cmd; cmd = new SqlCommand(insertRentQuery, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CustomerID", rent.CustomerID); cmd.Parameters.AddWithValue("@RentDate", rent.RentDate); cmd.Parameters.AddWithValue("@TotalAmount", rent.TotalAmount); cmd.ExecuteNonQuery(); cmd.Dispose(); // insert Employee foreach (RentDetail detail in detaillist) { cmd = new SqlCommand(insertRentDetailQuery, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@IndCanoeID", detail.IndCanoeID); cmd.Parameters.AddWithValue("@ReturnDueDate", detail.ReturnDueDate); cmd.Parameters.AddWithValue("@PenaltyAmount", detail.PenaltyAmount); cmd.Parameters.AddWithValue("@Quantity", detail.Quantity); cmd.Parameters.AddWithValue("@LIAmountTotal", detail.LIAmountTotal); cmd.ExecuteNonQuery(); cmd.Dispose(); cmd = new SqlCommand(updateIndStatusQuery, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Status", "loan"); cmd.Parameters.AddWithValue("@IndCanoeID", detail.IndCanoeID); cmd.ExecuteNonQuery(); cmd.Dispose(); } // close con.Close(); con.Dispose(); return true; } catch (Exception ex) { throw new CanoeException("DAOinsertRent", ex.Message); } }
// insert Rent public bool insertDAORent(Rent rent, ArrayList detaillist) { db = new DatabaseAccess(); db.DAOinsertRent(rent, detaillist); return true; }
// Rent make instance private void makeReturnInstance() { manage.rentlist = manage.makeRentList(); rent = manage.makeRent(customer.CID, manage.getMinRentDay(), null, totalAmount); }
// make Rent instance public Rent makeRent(int customerID, DateTime? rentDate, DateTime? returnDate, decimal totalAmount) { Rent rent = new Rent( customerID, rentDate, returnDate, totalAmount ); return rent; }
// Rent make instance private void makeRentInstance() { DateTime? d = DateTime.Parse(rentDate); rent = manage.makeRent(customer.CID, d, null, manage.totalAmount); manage.rentlist = manage.makeRentList(); }