public static List <Theart> getALlArea(int id)
{
List <Theart> list = new List <Theart>();
string sql = "select a.name,a.image,a.diaDiem,a.fax,a.hotline from Rap as a inner join KhuVuc as b on a.idLoaiRap = b.id where b.id = @id";
SqlCommand sqlCommand = new SqlCommand(sql, DataAccess.getConnection());
sqlCommand.Parameters.Add(new SqlParameter("@id", id));
sqlCommand.Connection.Open();
SqlDataReader data = sqlCommand.ExecuteReader();
if (data.HasRows)
{
while (data.Read())
{
Theart th = new Theart();
th.Name = data["name"].ToString();
th.Image = data["image"].ToString();
th.Place = data["diaDiem"].ToString();
th.Fax = data["fax"].ToString();
th.Hottline = data["hotline"].ToString();
list.Add(th);
}
}
sqlCommand.Connection.Close();
return(list);
}
public static Theart getThearterById(int id)
{
Theart t = new Theart();
string sql = "SELECT * FROM dbo.Rap WHERE id = @id ";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@id", SqlDbType.Int)
};
para[0].Value = id;
DataTable dt = DataAccess.ReadDataBySQLWithParameter(sql, para);
foreach (DataRow dr in dt.Rows)
{
t.ID = Convert.ToInt32(dr["id"].ToString());
t.Name = dr["name"].ToString();
t.Image = dr["image"].ToString();
t.Place = dr["diaDiem"].ToString();
t.Fax = dr["fax"].ToString();
}
return(t);
}
public static Theart getTheartByID(int a)
{
Theart r = new Theart();
string sql = "SELECT id,name,image,diaDiem,idKhuVuc,fax,hotline,idLoaiRap FROM dbo.Rap WHERE id = @id";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@id", SqlDbType.Int)
};
param[0].Value = a;
DataTable dt = DataAccess.ReadDataBySQLWithParameter(sql, param);
foreach (DataRow dr in dt.Rows)
{
r.ID = Convert.ToInt32(dr["id"].ToString());
r.Name = dr["name"].ToString();
r.Image = dr["image"].ToString();
r.Areax = AreaDAO.getAreaByID(Convert.ToInt32(dr["idKhuVuc"].ToString()));
r.TheaterTypex = TheartTypeDAO.getTheaterTypeByID(Convert.ToInt32(dr["idLoaiRap"].ToString()));
r.Fax = dr["fax"].ToString();
r.Hottline = dr["hotline"].ToString();
}
return(r);
}
public static List <Theart> getAlltTheart()
{
List <Theart> list = new List <Theart>();
string sql = "SELECT * FROM dbo.Rap";
DataTable a = DataAccess.ReadDataBySQL(sql);
foreach (DataRow dr in a.Rows)
{
Theart r = new Theart();
r.ID = Convert.ToInt32(dr["id"].ToString());
r.Name = dr["name"].ToString();
r.Image = dr["image"].ToString();
r.Place = dr["diaDiem"].ToString();
//r.Areax = Convert.ToInt32(dr["idKhuVuc"].ToString());
r.Fax = dr["fax"].ToString();
r.Hottline = dr["hotline"].ToString();
//r.TheaterTypex
list.Add(r);
}
return(list);
}
