public void CreateRentalRecord(RentalRecord record) { RentalDAO rentalDAO = RentalDAO.Instance; try { rentalDAO.OpenConnection(); rentalDAO.InsertRentalRecord(record); } catch (Exception) { throw; } finally { rentalDAO.CloseConnection(); } }
public void InsertRentalRecord(RentalRecord record) { SqlParameter pCustomerId = new SqlParameter("@CustomerID", SqlDbType.BigInt, 8); SqlParameter pPlateNum = new SqlParameter("@PlateNum", SqlDbType.NVarChar, 10); SqlParameter pRentalPeriod = new SqlParameter("@RentalPeriod", SqlDbType.SmallInt, 2); SqlParameter pRentStartDate = new SqlParameter("@RentStartDate", SqlDbType.Date, 3); cmInsertRentalRecord.Parameters.Clear(); cmInsertRentalRecord.Parameters.AddRange(new SqlParameter[] { pCustomerId, pPlateNum, pRentalPeriod, pRentStartDate }); pCustomerId.Value = record.RentingCustomer.CustomerID; pPlateNum.Value = record.RentedVehicle.PlateNum; pRentalPeriod.Value = record.RentalPeriod; pRentStartDate.Value = record.RentStartDate; cmInsertRentalRecord.ExecuteNonQuery(); }
public FormRentDetails(RentVehicleControl rentvehiclecontrol) { InitializeComponent(); this.rentvehiclecontrol = rentvehiclecontrol; record = new RentalRecord(); }