public List <KhuyenMaiDTO> select()
{
Fxuly xuLy = new Fxuly();
List <KhuyenMaiDTO> listKM = new List <KhuyenMaiDTO>();
string query = String.Empty;
query += "select [MAKM], [TENKM], [TGBD], [TGKT], [MUCGIAMGIA] from [KHUYENMAI]";
using (SqlConnection con = new SqlConnection(xuLy.ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = query;
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
KhuyenMaiDTO db = new KhuyenMaiDTO();
db.Makm = int.Parse(reader["MAKM"].ToString());
db.Tenkm = reader["TENKM"].ToString();
db.TgBD = DateTime.Parse(reader["TGBD"].ToString());
db.TgKT = DateTime.Parse(reader["TGKT"].ToString());
db.Mucgiamgia = int.Parse(reader["MUCGIAMGIA"].ToString());
listKM.Add(db);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
con.Dispose();
}
}
return(listKM);
}
}
public List <KhuyenMaiDTO> selectLoadCB()
{
string query = String.Empty;
Fxuly xuLy = new Fxuly();
query += "select [MAKM], [TENKM], [MUCGIAMGIA] FROM [KHUYENMAI] ";
List <KhuyenMaiDTO> list = new List <KhuyenMaiDTO>();
using (SqlConnection con = new SqlConnection(xuLy.ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
KhuyenMaiDTO kn = new KhuyenMaiDTO();
kn.maKhuyenMai = int.Parse(reader["MAKM"].ToString());
kn.tenKhuyenMai = reader["TENKM"].ToString();
kn.mucKhuyenMai = int.Parse(reader["MUCGIAMGIA"].ToString());
list.Add(kn);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
return(list);
}
}