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