public bool Update(PhanQuyen phanQuyen)
{
try
{
string query = "SELECT * FROM PhanQuyen";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, connection);
DataRow row = table.Rows.Find(phanQuyen.PhanQuyenId);
if (row != null)
{
row["tenNhomChucNang"] = phanQuyen.TenNhomChucNang;
row["tenChucNang"] = phanQuyen.TenChucNang;
row["chucNangThem"] = phanQuyen.ChucNangThem;
row["chucNangSua"] = phanQuyen.ChucNangSua;
row["chucNangXoa"] = phanQuyen.ChucNangXoa;
row["chucNangDoc"] = phanQuyen.ChucNangDoc;
row["NguoiDungId"] = phanQuyen.NguoiDungId;
}
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(dataAdapter);
dataAdapter.Update(table);
return(true);
}
catch
{
return(false);
}
}
public bool Insert(PhanQuyen phanQuyen)
{
try
{
string query = "SELECT * FROM PhanQuyen";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, connection);
table = GetData();
DataRow row = table.NewRow();
row["tenNhomChucNang"] = phanQuyen.TenNhomChucNang;
row["tenChucNang"] = phanQuyen.TenChucNang;
row["chucNangThem"] = phanQuyen.ChucNangThem;
row["chucNangSua"] = phanQuyen.ChucNangSua;
row["chucNangXoa"] = phanQuyen.ChucNangXoa;
row["chucNangDoc"] = phanQuyen.ChucNangDoc;
row["NguoiDungId"] = phanQuyen.NguoiDungId;
table.Rows.Add(row);
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(dataAdapter);
dataAdapter.Update(table);
return(true);
}
catch
{
return(false);
}
}
// Phân Quyền Nhân Viên
public DataTable PhanQuyenNhanVien(PhanQuyen pq)
{
OpenConnection();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "sp_INSERT_CTCN_UPDATE_CHUCNANG";
sqlCommand.Connection = conn;
sqlCommand.Parameters.Add("@MAQH", SqlDbType.NChar).Value = pq.idPermission;
sqlCommand.Parameters.Add("@DANHMUC", SqlDbType.Bit).Value = pq.DanhMuc;
sqlCommand.Parameters.Add("@QUANLYBANHANG", SqlDbType.Bit).Value = pq.QuanLyBanHang;
sqlCommand.Parameters.Add("@THONGKE", SqlDbType.Bit).Value = pq.ThongKe;
sqlCommand.Parameters.Add("@SAOLUU", SqlDbType.Bit).Value = pq.SaoLuu;
sqlCommand.Parameters.Add("@HELP", SqlDbType.Bit).Value = pq.Help;
sqlCommand.Parameters.Add("@MACN", SqlDbType.NChar).Value = pq.idChucNang;
sqlCommand.Parameters.Add("@TENCHUCNANG", SqlDbType.NChar).Value = pq.nameChucNang;
sqlCommand.Parameters.Add("@INSERTS", SqlDbType.Bit).Value = pq.Inserts;
sqlCommand.Parameters.Add("@UPDATES", SqlDbType.Bit).Value = pq.Updates;
sqlCommand.Parameters.Add("@DELETES", SqlDbType.Bit).Value = pq.Deletes;
sqlCommand.Parameters.Add("@SEARCH", SqlDbType.Bit).Value = pq.Searchs;
sqlCommand.Parameters.Add("@PRINTS", SqlDbType.Bit).Value = pq.In;
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlCommand);
DataTable dt = new DataTable();
sqlAdapter.Fill(dt);
return(dt);
}
public bool capNhatQuyen(UpdateQuyenModel updates)
{
try
{
PhanQuyen phanQuyen = db.PhanQuyens.FirstOrDefault(t => t.MaNhom.Equals(updates.MaNhom) && t.ManHinh.MaManHinh.Equals(updates.MaMH));
phanQuyen.CoQuyen = updates.Quyen;
db.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
// Hiển Thi Danh Sách Chức Năng Trong Bảng Nhân Viên
public List <PhanQuyen> HienThiDanhSachChucNang(PhanQuyen pq)
{
try
{
OpenConnection();
List <PhanQuyen> pqlist = new List <PhanQuyen>();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "sp_SELECT_CHUCNANG";
sqlCommand.Connection = conn;
sqlCommand.Parameters.Add("@MACN", SqlDbType.NChar).Value = pq.idChucNang;
sqlCommand.Parameters.Add("@TENCHUCNANG", SqlDbType.NChar).Value = pq.nameChucNang;
SqlDataReader sqlReader = sqlCommand.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(sqlReader);
for (int i = 0; i < dt.Rows.Count; i++)
{
PhanQuyen pqs = new PhanQuyen();
pqs.Inserts = int.Parse(dt.Rows[i][0].ToString());
pqs.Updates = int.Parse(dt.Rows[i][0].ToString());
pqs.Deletes = int.Parse(dt.Rows[i][0].ToString());
pqs.In = int.Parse(dt.Rows[i][0].ToString());
pqs.Searchs = int.Parse(dt.Rows[i][0].ToString());
pqlist.Add(pqs);
}
sqlReader.Close();
return(pqlist);
}
catch
{
throw;
}
finally
{
CloseConnection();
}
}
public string GetSDT(string sdt)
{
PhanQuyen check = context.PhanQuyens.Where(t => t.SDT.Equals(sdt)).FirstOrDefault();
return(check.SDT.ToString());
}
partial void DeletePhanQuyen(PhanQuyen instance);
partial void UpdatePhanQuyen(PhanQuyen instance);
partial void InsertPhanQuyen(PhanQuyen instance);
