// FrontOffice Frm public List <Reservations> Search(DateTime _CheckOut) { SqlConnection Connection = DBGate.GetConnection(); string SelectAll = " select * from Reservations where CheckOut >= @Out "; SqlCommand cmd = new SqlCommand(SelectAll, Connection); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Out", _CheckOut); List <Reservations> lst = new List <Reservations>(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Reservations _obj = new Reservations(); _obj.ID = int.Parse(reader["ID"].ToString()); _obj.FirstName = reader["FirstName"].ToString(); _obj.LastName = reader["LastName"].ToString(); _obj.Mobile = reader["Mobile"].ToString(); _obj.UniteName = reader["UniteName"].ToString(); // _obj.CheckIn = DateTime.Parse(reader["CheckIn"].ToString()); _obj.CheckOut = DateTime.Parse(reader["CheckOut"].ToString()); _obj.Bookedon = DateTime.Parse(reader["Bookedon"].ToString()); _obj.Status = reader["Status"].ToString(); _obj.Days = int.Parse(reader["Days"].ToString()); // _obj.TotalPrice = double.Parse(reader["TotalPrice"].ToString()); _obj.Commission = double.Parse(reader["Commission"].ToString()); _obj.RoomNo = reader["RoomNo"].ToString(); lst.Add(_obj); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(lst); }
public DAL.Reservations GetByID(int ID) { SqlConnection Connection = DBGate.GetConnection(); string SelectByID = "Select * from Reservations where ID = @ID "; SqlCommand cmd = new SqlCommand(SelectByID, Connection); cmd.Parameters.AddWithValue("@ID", ID); Reservations _obj = new Reservations(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { _obj.ID = int.Parse(reader["ID"].ToString()); _obj.FirstName = reader["FirstName"].ToString(); _obj.LastName = reader["LastName"].ToString(); _obj.Mobile = reader["Mobile"].ToString(); _obj.UniteName = reader["UniteName"].ToString(); // _obj.CheckIn = DateTime.Parse(reader["CheckIn"].ToString()); _obj.CheckOut = DateTime.Parse(reader["CheckOut"].ToString()); _obj.Bookedon = DateTime.Parse(reader["Bookedon"].ToString()); _obj.Status = reader["Status"].ToString(); _obj.Days = int.Parse(reader["Days"].ToString()); // _obj.TotalPrice = double.Parse(reader["TotalPrice"].ToString()); _obj.Commission = double.Parse(reader["Commission"].ToString()); _obj.RoomNo = reader["RoomNo"].ToString(); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(_obj); }