public List <clsTaiKhoan> List_SelectTaiKhoan() { List <clsTaiKhoan> list = new List <clsTaiKhoan>(); try { dt = dh.ExecuteDataSet("usp_TAIKHOAN_Select", new SqlParameter[0]).Tables[0]; if (dt.Rows.Count != 0) { foreach (DataRow dr in dt.Rows) { clsTaiKhoan us = new clsTaiKhoan { MaNV = dr["MANV"] == DBNull.Value ? "" : dr["MANV"].ToString(), MatKhau = dr["MATKHAU"] == DBNull.Value ? "" : dr["MATKHAU"].ToString(), QuanLy = dr["ADM"] == DBNull.Value ? false : bool.Parse(dr["ADM"].ToString()), }; list.Add(us); } } } catch (Exception ex) { throw ex; } return(list); }
public bool ThemTaiKhoan(clsTaiKhoan tkAdd) { System.Data.Common.DbTransaction suaTran = db.Connection.BeginTransaction(); try { db.Transaction = suaTran; src.DAOs.DB_QLTD.tblTAIKHOAN tk = new DAOs.DB_QLTD.tblTAIKHOAN(); //vt.MaVT = 12; tk.ID_NV = tkAdd._Id_NV; tk.Usernames = tkAdd._StrUsername; tk.Passwords = tkAdd._StrPassWord; tk.MaRole_R = tkAdd._MaRole; db.tblTAIKHOANs.InsertOnSubmit(tk); db.SubmitChanges(); db.Transaction.Commit(); return(true); } catch { db.Transaction.Rollback(); return(false); } }