public BindingList <PhanQuyenDTO> LayDanhSach()
{
BindingList <PhanQuyenDTO> danhSach = new BindingList <PhanQuyenDTO>();
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Select * From SysDanhMucPhanQuyen";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
PhanQuyenDTO itemDTO = new PhanQuyenDTO();
itemDTO.Id = (int)dr["Id"];
itemDTO.IdNguoiDung = (int)dr["IdNguoiDung"];
itemDTO.IdChucNang = (int)dr["IdChucNang"];
itemDTO.IdPhanHe = (int)dr["IdPhanHe"];
itemDTO.Doc = (bool)dr["Doc"];
itemDTO.Them = (bool)dr["Them"];
itemDTO.Sua = (bool)dr["Sua"];
itemDTO.Xoa = (bool)dr["Xoa"];
danhSach.Add(itemDTO);
}
return(danhSach);
}
private void btnThem_Click(object sender, EventArgs e)
{
if (txtName.Text == "" || txtMaNV.Text == "" || txtPass.Text == "" || txtPhanQuyen.Text == "")
{
MessageBox.Show("Bạn phải nhập đầy đủ thông tin", "thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int id = Convert.ToInt32(txtMaNV.Text);
string name = txtName.Text;
string pass = txtPass.Text;
int phanquyen = Convert.ToInt32(txtPhanQuyen.Text);
PhanQuyenDTO PQ = new PhanQuyenDTO(id, name, pass, phanquyen);
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP POST
var postTask = client.PostAsJsonAsync <PhanQuyenDTO>("PhanQuyen", PQ);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
MessageBox.Show("Thêm TK thành công", "Thông báo", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("Thêm TK không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Load();
}
}
public List <PhanQuyenDTO> Search(string str)
{
List <PhanQuyenDTO> List = new List <PhanQuyenDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("EXEC USP_SearchDN @ten ", new object[] { str });
foreach (DataRow item in data.Rows)
{
PhanQuyenDTO dn = new PhanQuyenDTO(item);
List.Add(dn);
}
return(List);
}
public List <PhanQuyenDTO> GetDN()
{
List <PhanQuyenDTO> ListDN = new List <PhanQuyenDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from DANGNHAP");
foreach (DataRow item in data.Rows)
{
PhanQuyenDTO dn = new PhanQuyenDTO(item);
ListDN.Add(dn);
}
return(ListDN);
}
public IHttpActionResult Put(PhanQuyenDTO x)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
PhanQuyenDAO.Instance.Update(x.IDNV, x.Name, x.Pass, x.PhanQuyen);
}
catch (Exception)
{
}
return(Ok());
}
public PhanQuyenDTO getByTenPhanQuyen(string tenPhanQuyen)
{
PhanQuyenDTO pq = new PhanQuyenDTO();
string sql = " select * from PHANQUYEN where TenPhanQuyen=@TenPhanQuyen";
SqlParameter sp = new SqlParameter("@TenPhanQuyen", tenPhanQuyen);
DataTable dt = conectData.LoadData(sql, sp);
if (dt == null || dt.Rows.Count == 0)
return null;
else
{
pq.MaPhanQuyen = int.Parse(dt.Rows[0]["MaPhanQuyen"].ToString());
pq.TenPhanQuyen = dt.Rows[0]["TenPhanQuyen"].ToString();
}
return pq;
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtName.Text == "")
{
MessageBox.Show("phải chọn 1 TK để sửa!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var xacnhan = MessageBox.Show("bạn có chắc chắn muốn sửa TK : " + txtName.Text, "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (xacnhan == DialogResult.Yes)
{
int id = Convert.ToInt32(txtMaNV.Text);
string name = txtName.Text;
string pass = txtPass.Text;
int phanquyen = Convert.ToInt32(txtPhanQuyen.Text);
PhanQuyenDTO PQ = new PhanQuyenDTO(id, name, pass, phanquyen);
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP PUT
var postTask = client.PutAsJsonAsync <PhanQuyenDTO>("PhanQuyen", PQ);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
MessageBox.Show("Sửa TK thành công", "Thông báo", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("Sửa TK không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Load();
}
}
}
}
public void Sua(PhanQuyenDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Update SysDanhMucPhanQuyen Set Doc = ?, Them = ?, Sua = ?, Xoa = ? Where Id = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@Doc", OleDbType.Boolean).Value = itemDTO.Doc;
cmd.Parameters.Add("@Them", OleDbType.Boolean).Value = itemDTO.Them;
cmd.Parameters.Add("@Sua", OleDbType.Boolean).Value = itemDTO.Sua;
cmd.Parameters.Add("@Xoa", OleDbType.Boolean).Value = itemDTO.Xoa;
cmd.Parameters.Add("@Id", OleDbType.Numeric).Value = itemDTO.Id;
cmd.ExecuteNonQuery();
cn.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
PhanQuyenBUS phanQuyenBUS = new PhanQuyenBUS();
List <PhanQuyenDTO> phanQuyenDTOs = new List <PhanQuyenDTO>();
foreach (DataGridViewRow dr in dgvPhanQuyen.Rows)
{
PhanQuyenDTO item = new PhanQuyenDTO();
item.FormName = dr.Cells["FormName"].Value.ToString();
item.AllowAccess = bool.Parse(dr.Cells["AllowAccess"].Value.ToString());
item.AllowAdd = bool.Parse(dr.Cells["AllowAdd"].Value.ToString());
item.AllowDelete = bool.Parse(dr.Cells["AllowDelete"].Value.ToString());
item.AllowImport = bool.Parse(dr.Cells["AllowImport"].Value.ToString());
item.AllowUpdate = bool.Parse(dr.Cells["AllowUpdate"].Value.ToString());
item.AllowExport = bool.Parse(dr.Cells["AllowExport"].Value.ToString());
item.FormID = int.Parse(dr.Cells["FormID"].Value.ToString());
phanQuyenDTOs.Add(item);
}
phanQuyenBUS.SetRoleForm(phanQuyenDTOs, int.Parse(cbVaiTro.SelectedValue.ToString()));
}
public List <PhanQuyenDTO> loadDataDAO()
{
List <PhanQuyenDTO> lsQuyen = new List <PhanQuyenDTO>();
// ...
conn.Ketnoi();
string query = "SELECT * FROM PhanQuyen";
SqlDataReader reader = conn.getdata(query);
while (reader.Read())
{
PhanQuyenDTO quyen = new PhanQuyenDTO();
quyen.MaQuyen = reader.GetInt32(0);
quyen.TenQuyen = reader.GetString(1);
quyen.ChiTietQuyen = reader.GetString(2);
lsQuyen.Add(quyen);
}
// ...
conn.Ngatketnoi();
return(lsQuyen);
}
private void gvDanhSachPhanQuyen_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
if (gvDanhSachPhanQuyen.FocusedRowHandle > -1)
{
try
{
PhanQuyenDTO itemDTO = new PhanQuyenDTO();
PhanQuyenBUS itemBUS = new PhanQuyenBUS();
itemDTO.Doc = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Doc").ToString());
itemDTO.Them = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Them").ToString());
itemDTO.Sua = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Sua").ToString());
itemDTO.Xoa = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Xoa").ToString());
itemDTO.Id = int.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Id").ToString());
itemBUS.Sua(itemDTO);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void Them(PhanQuyenDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Insert into SysDanhMucPhanQuyen (IdNguoiDung, IdChucNang, IdPhanHe, Doc, Them, Sua, Xoa) values (?, ?, ?, ?, ?, ?, ?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@IdNguoiDung", OleDbType.Numeric).Value = itemDTO.IdNguoiDung;
cmd.Parameters.Add("@IdChucNang", OleDbType.Numeric).Value = itemDTO.IdChucNang;
cmd.Parameters.Add("@IdPhanHe", OleDbType.Numeric).Value = itemDTO.IdPhanHe;
cmd.Parameters.Add("@Doc", OleDbType.Boolean).Value = itemDTO.Doc;
cmd.Parameters.Add("@Them", OleDbType.Boolean).Value = itemDTO.Them;
cmd.Parameters.Add("@Sua", OleDbType.Boolean).Value = itemDTO.Sua;
cmd.Parameters.Add("@Xoa", OleDbType.Boolean).Value = itemDTO.Xoa;
cmd.ExecuteNonQuery();
cn.Close();
}
public void Sua(PhanQuyenDTO itemDTO)
{
PhanQuyenDAO itemDAO = new PhanQuyenDAO();
itemDAO.Sua(itemDTO);
}
// list of all PhanQuyen
public PhanQuyenDTO[] getList()
{
PhanQuyenDTO[] list;
string sql = " select * from PHANQUYEN";
DataTable dt = new DataTable();
dt = conectData.LoadData(sql);
if (dt == null || dt.Rows.Count == 0)
return null;
else
{
list = new PhanQuyenDTO[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
list[i] = new PhanQuyenDTO();
list[i].MaPhanQuyen = int.Parse(dt.Rows[i]["MaPhanQuyen"].ToString());
list[i].TenPhanQuyen = dt.Rows[i]["TenPhanQuyen"].ToString();
}
}
return list;
}
public int update(PhanQuyenDTO pq)
{
string sql = "update PHANQUYEN set TenPhanQuyen=@TenPhanQuyen where MaPhanQuyen=@MaPhanQuyen";
SqlParameter[] sp = new SqlParameter[2];
sp[0] = new SqlParameter("@TenPhanQuyen", pq.TenPhanQuyen);
sp[1] = new SqlParameter("@MaPhanQuyen", pq.MaPhanQuyen);
return conectData.Insert_Update_Delete(sql, sp);
}
public int insert(PhanQuyenDTO pq)
{
string sql = "insert into PHANQUYEN values (@TenPhanQuyen)";
SqlParameter sp = new SqlParameter("@TenPhanQuyen", pq.TenPhanQuyen);
return conectData.Insert_Update_Delete(sql, sp);
}
public void Them(PhanQuyenDTO itemDTO)
{
PhanQuyenDAO itemDAO = new PhanQuyenDAO();
itemDAO.Them(itemDTO);
}