public string AddPackage(TouristPackage oTourist)
{
var message = "agrege";
cs.AddPackage(oTourist);
return(message);
}
public List <TouristPackage> GetPackage()
{
conexion.Open();
SqlCommand c = conexion.CreateCommand();
c.Connection = conexion;
c.CommandType = CommandType.StoredProcedure;
c.CommandText = "Get_Package";
SqlDataReader dn = c.ExecuteReader();
ListPackage.Clear();
while (dn.Read())
{
string descripcion = dn.GetString(1);
DateTime chekIn = dn.GetDateTime(3);
DateTime chekOut = dn.GetDateTime(2);
double import = dn.GetDouble(5);
int cantidad = dn.GetInt32(4);
TouristPackage oTourist = new TouristPackage(cantidad, import, descripcion, chekOut, chekIn);
oTourist.IdPackage = dn.GetInt32(0);
ListPackage.Add(oTourist);
}
dn.Close();
conexion.Close();
return(ListPackage);
}
public int AddPackage(TouristPackage oTouristPackage)
{
conexion.Open();
SqlCommand c = conexion.CreateCommand();
c.Connection = conexion;
c.CommandType = CommandType.StoredProcedure;
c.CommandText = "Add_Package";
c.Parameters.AddWithValue("description", oTouristPackage.Description);
c.Parameters.AddWithValue("checkOut", oTouristPackage.CheckOut);
c.Parameters.AddWithValue("checkIn", oTouristPackage.CheckIn);
c.Parameters.AddWithValue("quantity", oTouristPackage.Quantity);
c.Parameters.AddWithValue("import", oTouristPackage.Import);
int AffectedRow = c.ExecuteNonQuery();
conexion.Close();
return(AffectedRow);
}
public int ModifyPackage(TouristPackage oTouristPackage)
{
throw new NotImplementedException();
}
public void AddPackage(TouristPackage oTourist)
{
ListPackage.AddPackage(oTourist);
}
public void AddPackage(string description, DateTime checkOut, DateTime checkIn, int quantity, double import)
{
TouristPackage oTourist = new TouristPackage(quantity, import, description, checkOut, checkIn);
ListPackage.AddPackage(oTourist);
}
