public static List <ChucNang_LoaiTaiKhoanDTO> LayDanhSachChucNang_LoaiTaiKhoanTheoMaTaiKhoan(int maTaiKhoan) { SqlConnection connection = DataProvider.GetConnection(); string query = "SELECT ma_chuc_nang, ChucNang_LoaiTaiKhoan.ma_loai_tai_khoan FROM ChucNang_LoaiTaiKhoan, TaiKhoan WHERE TaiKhoan.ma_tai_khoan=@maTaiKhoan AND TaiKhoan.loai_tai_khoan=ChucNang_LoaiTaiKhoan.ma_loai_tai_khoan"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Add("@maTaiKhoan", System.Data.SqlDbType.Int, 0).Value = maTaiKhoan; command.Connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <ChucNang_LoaiTaiKhoanDTO> result = new List <ChucNang_LoaiTaiKhoanDTO>(); if (reader.HasRows) { while (reader.Read()) { ChucNang_LoaiTaiKhoanDTO chucNang_LoaiTaiKhoan = new ChucNang_LoaiTaiKhoanDTO(); chucNang_LoaiTaiKhoan.MaChucNang = reader.GetInt32(0); chucNang_LoaiTaiKhoan.MaLoaiTaiKhoan = reader.GetInt32(1); result.Add(chucNang_LoaiTaiKhoan); } } command.Connection.Close(); return(result); }
private List <ChucNang_LoaiTaiKhoanDTO> LayDanhSachCheckBoxChucNang(bool themLoaiTaiKhoan) { int maLoaiTaiKhoan; if (themLoaiTaiKhoan) { maLoaiTaiKhoan = LoaiTaiKhoanBUS.LayMaLoaiTaiKhoanMoiNhat() + 1; } else { maLoaiTaiKhoan = Convert.ToInt32(txtMaLoaiTaiKhoan.Text); } List <ChucNang_LoaiTaiKhoanDTO> lsChucNang_LoaiTaiKhoan = new List <ChucNang_LoaiTaiKhoanDTO>(); foreach (Control ctrl in gpbChucNang.Controls) { if (ctrl.GetType() == typeof(MetroCheckBox)) { if (((MetroCheckBox)ctrl).Checked) { ChucNang_LoaiTaiKhoanDTO chucNang_LoaiTaiKhoan = new ChucNang_LoaiTaiKhoanDTO(); chucNang_LoaiTaiKhoan.MaChucNang = Convert.ToInt32(ctrl.AccessibleName); chucNang_LoaiTaiKhoan.MaLoaiTaiKhoan = maLoaiTaiKhoan; lsChucNang_LoaiTaiKhoan.Add(chucNang_LoaiTaiKhoan); } } } return(lsChucNang_LoaiTaiKhoan); }
public static bool ThemChucNang_LoaiTaiKhoan(ChucNang_LoaiTaiKhoanDTO chucNang_LoaiTaiKhoan) { SqlConnection connection = DataProvider.GetConnection(); string query = "INSERT INTO ChucNang_LoaiTaiKhoan (ma_chuc_nang, ma_loai_tai_khoan) VALUES (@maChucNang, @maLoaiTaiKhoan)"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Add("@maChucNang", System.Data.SqlDbType.Int, 0).Value = chucNang_LoaiTaiKhoan.MaChucNang; command.Parameters.Add("@maLoaiTaiKhoan", System.Data.SqlDbType.Int, 0).Value = chucNang_LoaiTaiKhoan.MaLoaiTaiKhoan; connection.Open(); int reader = command.ExecuteNonQuery(); connection.Close(); if (reader > 0) { return(true); } return(false); }