private bool CheckTonTai(string strDoiTuong)
{
bool kq = false;
clsDM_ChuyenDoiMucHuong obj = new clsDM_ChuyenDoiMucHuong();
kq = obj.CheckTonTai(strDoiTuong);
return kq;
}
public static List<clsDM_ChuyenDoiMucHuong> GetListChuyenDoi()
{
List<clsDM_ChuyenDoiMucHuong> lst = new List<clsDM_ChuyenDoiMucHuong>();
SQLiteConnection m_dbConnection = new SQLiteConnection(ConfigurationManager.AppSettings["ConnectionString"]);
m_dbConnection.Open();
DataTable dt = new DataTable();
string sql = "select * from DM_ChuyenDoi order by DoiTuong";
SQLiteCommand cmd = new SQLiteCommand(sql, m_dbConnection);
SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);
da.Fill(dt);
m_dbConnection.Close();
foreach (DataRow row in dt.Rows)
{
clsDM_ChuyenDoiMucHuong mh = new clsDM_ChuyenDoiMucHuong();
mh.ChuyenDoi_Id = int.Parse(row["ChuyenDoi_Id"].ToString());
mh.DoiTuong = row["DoiTuong"].ToString();
mh.MucHuongCu = int.Parse(row["MucHuongCu"].ToString());
mh.MucHuongMoi = int.Parse(row["MucHuongMoi"].ToString());
lst.Add(mh);
}
return lst;
}
private void LoadGridView()
{
clsDM_ChuyenDoiMucHuong obj = new clsDM_ChuyenDoiMucHuong();
TableChuyenDoiMucHuong = obj.GetAll();
grdDM_ChuyenDoiMucHuong.DataSource = TableChuyenDoiMucHuong;
}