public static List <ResortManagerDTO.DTO.TaiKhoan> SelectLoginUser(out ResortManagerDTO.DTO.DbAck ack) { Provider provider = new Provider(); ack = provider.Connect(); if (ack == ResortManagerDTO.DTO.DbAck.NetworkError) { return(null); } DataTable dt = new DataTable(); dt = provider.Select(CommandType.StoredProcedure, "SelectLoginUser", out ack, null); List <ResortManagerDTO.DTO.TaiKhoan> lstUser = new List <ResortManagerDTO.DTO.TaiKhoan>(); if (dt == null) { return(null); } foreach (DataRow row in dt.Rows) { ResortManagerDTO.DTO.TaiKhoan user = new ResortManagerDTO.DTO.TaiKhoan { TenTaiKhoan = row["TENTAIKHOAN"].ToString(), MatKhau = row["MATKHAU"].ToString(), MaDoan = row["MADOAN"].ToString() }; lstUser.Add(user); } provider.Disconnect(); return(lstUser); }
public static ResortManagerDTO.DTO.DbAck ThemTaiKhoan(ResortManagerDTO.DTO.TaiKhoan tk) { Provider provider = new Provider(); ResortManagerDTO.DTO.DbAck result = provider.Connect(); if (result == ResortManagerDTO.DTO.DbAck.NetworkError) { goto Network; // net nhu la networkerror thi nhay den lable network } SqlParameter[] para = new SqlParameter[] { new SqlParameter("@TenTK", tk.TenTaiKhoan), new SqlParameter("@MatKhau", tk.MatKhau), new SqlParameter("@MaDoan", tk.MaDoan) }; result = provider.ExcuteNonQuery(CommandType.StoredProcedure, "usp_ThemTaiKhoan", para); provider.Disconnect(); //lable network Network: return(result); }
public static ResortManagerDTO.DTO.DbAck ThemTaiKhoan(ResortManagerDTO.DTO.TaiKhoan tk) { return(ResortManagerDAO.DAO.TaiKhoan.ThemTaiKhoan(tk)); }