public List <ReservationDM> GetReservationList() { List <ReservationDM> reservationList = new List <ReservationDM>(); DBUtilities utility = new DBUtilities(); utility.cn.Open(); utility.cmd.CommandText = "sp_getReservation"; utility.cmd.ExecuteScalar(); SqlDataReader dr = utility.cmd.ExecuteReader(); while (dr.Read()) { ReservationDM cdm = new ReservationDM(); cdm.ID = Convert.ToInt32(dr["ID"]); cdm.Day = Convert.ToInt32(dr["Day"]); cdm.Date = Convert.ToDateTime(dr["Date"]); cdm.EndDate = Convert.ToDateTime(dr["EndDate"]); cdm.Amount = Convert.ToInt32(dr["Amount"]); reservationList.Add(cdm); } dr.Close(); utility.endC(); return(reservationList); }
public List <ReservationDM> ReservationDetail(int ID) { List <ReservationDM> carList = new List <ReservationDM>(); DBUtilities utility = new DBUtilities(); utility.cn.Open(); utility.cmd.CommandText = "sp_ReservationDetail"; utility.cmd.Parameters.Add("ID", ID); utility.cmd.ExecuteScalar(); SqlDataReader dr = utility.cmd.ExecuteReader(); while (dr.Read()) { ReservationDM cdm = new ReservationDM(); cdm.ID = Convert.ToInt32(dr["ID"]); cdm.Date = Convert.ToDateTime(dr["Date"]); cdm.EndDate = Convert.ToDateTime(dr["EndDate"]); cdm.Amount = Convert.ToInt32(dr["Amount"]); cdm.CustomerName = dr["CustomerName"].ToString(); cdm.CustomerSurname = dr["CustomerSurname"].ToString(); cdm.CustomerPhone = dr["CustomerPhone"].ToString(); cdm.LicensePlate = dr["LicensePlate"].ToString(); cdm.ChassisNumber = dr["ChassisNumber"].ToString(); cdm.Marka = dr["BrandName"].ToString(); carList.Add(cdm); } dr.Close(); utility.endC(); return(carList); }
public void AddReservation(ReservationDM reservation) { DBUtilities utility = new DBUtilities(); utility.cn.Open(); utility.cmd.CommandText = "sp_InsertReservation"; utility.cmd.Parameters.Add("Date", reservation.Date); utility.cmd.Parameters.Add("Day", reservation.Day); utility.cmd.Parameters.Add("EndDate", reservation.EndDate); utility.cmd.Parameters.Add("Amount", reservation.Amount); utility.cmd.Parameters.Add("Customer", reservation.Customer); utility.cmd.Parameters.Add("Car", reservation.Car); utility.cmd.ExecuteScalar(); utility.endC(); }