public Budget_BookingOnline SelectByConfirmationIDAndLastname(string ConfirmationID, string LastName)
{
Budget_BookingOnline booking = null;
try
{
string sSQL = @"SELECT * FROM BookingOnline WHERE ConfirmationID=@ConfirmationID AND LastName=@LastName";
SqlParameter[] sqlParam = new SqlParameter[2];
sqlParam[0] = new SqlParameter("@ConfirmationID", SqlDbType.NVarChar);
sqlParam[0].Value = ConfirmationID;
sqlParam[1] = new SqlParameter("@LastName", SqlDbType.NVarChar);
sqlParam[1].Value = LastName;
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
if (ds.Tables[0].Rows.Count > 0)
{
booking = new Budget_BookingOnline();
booking.BookingOID = new Guid(ds.Tables[0].Rows[0]["BookingOID"].ToString());
booking.FirstName = ds.Tables[0].Rows[0]["FirstName"].ToString();
booking.LastName = ds.Tables[0].Rows[0]["LastName"].ToString();
booking.Contact = ds.Tables[0].Rows[0]["Contact"].ToString();
booking.Flight = ds.Tables[0].Rows[0]["Flight"].ToString();
booking.Email = ds.Tables[0].Rows[0]["Email"].ToString();
booking.ConfirmationID = ds.Tables[0].Rows[0]["ConfirmationID"].ToString();
booking.Price = Convert.ToDouble(ds.Tables[0].Rows[0]["Price"].ToString());
booking.GroupType = ds.Tables[0].Rows[0]["GroupType"].ToString();
booking.GroupValue = ds.Tables[0].Rows[0]["GroupValue"].ToString();
booking.RateQualifier = (ds.Tables[0].Rows[0]["RateQualifier"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[0]["RateQualifier"].ToString() : "";
booking.CurrencyCode = ds.Tables[0].Rows[0]["CurrencyCode"].ToString();
booking.PickupLocation = (ds.Tables[0].Rows[0]["PickupLocation"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[0]["PickupLocation"].ToString() : "";
if (ds.Tables[0].Rows[0]["PickupDateTime"].Equals(DBNull.Value) == false)
{
booking.PickupDateTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["PickupDateTime"].ToString());
}
booking.ReturnLocation = (ds.Tables[0].Rows[0]["ReturnLocation"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[0]["ReturnLocation"].ToString() : "";
if (ds.Tables[0].Rows[0]["ReturnDateTime"].Equals(DBNull.Value) == false)
{
booking.ReturnDateTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["ReturnDateTime"].ToString());
}
booking.CarName = ds.Tables[0].Rows[0]["CarName"].ToString();
booking.Citizen = ds.Tables[0].Rows[0]["Citizen"].ToString();
booking.VehType = ds.Tables[0].Rows[0]["VehType"].ToString();
booking.VehClass = ds.Tables[0].Rows[0]["VehClass"].ToString();
booking.ChildSeatQty = int.Parse(ds.Tables[0].Rows[0]["ChildSeatQty"].ToString());
booking.ChildSeatPrice = (ds.Tables[0].Rows[0]["ChildSeatPrice"].Equals(DBNull.Value) == false) ? Convert.ToDouble(ds.Tables[0].Rows[0]["ChildSeatPrice"].ToString()) : 0;
booking.BookingStatus = (ds.Tables[0].Rows[0]["BookingStatus"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[0]["BookingStatus"].ToString() : "";
if (ds.Tables[0].Rows[0]["BookingDateTime"].Equals(DBNull.Value) == false)
{
booking.BookingDateTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["BookingDateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["ModifyDateTime"].Equals(DBNull.Value) == false)
{
booking.ModifyDateTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["ModifyDateTime"].ToString());
}
}
}
catch (Exception ex) { }
return(booking);
}
public List <Budget_BookingOnline> SelectAll()
{
List <Budget_BookingOnline> BookingList = null;
try
{
string sSQL = @"SELECT * FROM BookingOnline";
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
if (ds.Tables[0].Rows.Count > 0)
{
BookingList = new List <Budget_BookingOnline>();
Budget_BookingOnline booking = new Budget_BookingOnline();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
booking = new Budget_BookingOnline();
booking.BookingOID = new Guid(ds.Tables[0].Rows[i]["BookingOID"].ToString());
booking.FirstName = ds.Tables[0].Rows[i]["FirstName"].ToString();
booking.LastName = ds.Tables[0].Rows[i]["LastName"].ToString();
booking.Contact = ds.Tables[0].Rows[i]["Contact"].ToString();
booking.Flight = ds.Tables[0].Rows[i]["Flight"].ToString();
booking.Email = ds.Tables[0].Rows[i]["Email"].ToString();
booking.ConfirmationID = ds.Tables[0].Rows[i]["ConfirmationID"].ToString();
booking.Price = Convert.ToDouble(ds.Tables[0].Rows[i]["Price"].ToString());
booking.GroupType = ds.Tables[0].Rows[i]["GroupType"].ToString();
booking.GroupValue = ds.Tables[0].Rows[i]["GroupValue"].ToString();
booking.RateQualifier = (ds.Tables[0].Rows[i]["RateQualifier"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["RateQualifier"].ToString() : "";
booking.CurrencyCode = ds.Tables[0].Rows[i]["CurrencyCode"].ToString();
booking.PickupLocation = (ds.Tables[0].Rows[i]["PickupLocation"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["PickupLocation"].ToString() : "";
if (ds.Tables[0].Rows[i]["PickupDateTime"].Equals(DBNull.Value) == false)
{
booking.PickupDateTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["PickupDateTime"].ToString());
}
booking.ReturnLocation = (ds.Tables[0].Rows[i]["ReturnLocation"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["ReturnLocation"].ToString() : "";
if (ds.Tables[0].Rows[i]["ReturnDateTime"].Equals(DBNull.Value) == false)
{
booking.ReturnDateTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["ReturnDateTime"].ToString());
}
booking.CarName = ds.Tables[0].Rows[i]["CarName"].ToString();
booking.Citizen = ds.Tables[0].Rows[i]["Citizen"].ToString();
booking.VehType = ds.Tables[0].Rows[i]["VehType"].ToString();
booking.VehClass = ds.Tables[0].Rows[i]["VehClass"].ToString();
booking.ChildSeatQty = int.Parse(ds.Tables[0].Rows[i]["ChildSeatQty"].ToString());
booking.ChildSeatPrice = (ds.Tables[0].Rows[i]["ChildSeatPrice"].Equals(DBNull.Value) == false) ? Convert.ToDouble(ds.Tables[0].Rows[i]["ChildSeatPrice"].ToString()) : 0;
booking.BookingStatus = (ds.Tables[0].Rows[i]["BookingStatus"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["BookingStatus"].ToString() : "";
if (ds.Tables[0].Rows[i]["BookingDateTime"].Equals(DBNull.Value) == false)
{
booking.BookingDateTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["BookingDateTime"].ToString());
}
if (ds.Tables[0].Rows[i]["ModifyDateTime"].Equals(DBNull.Value) == false)
{
booking.ModifyDateTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["ModifyDateTime"].ToString());
}
BookingList.Add(booking);
}
}
}
catch (Exception ex) { }
return(BookingList);
}