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