public static List <ChucVu_DTO> HienThiDanhSachChucVu(int index)
{
List <ChucVu_DTO> lstChucVu = new List <ChucVu_DTO>();
try
{
string strTruyVan = string.Format("SELECT * FROM ChucVu");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
for (index = 0; index < _dt.Rows.Count; index++)
{
ChucVu_DTO cvDTO = new ChucVu_DTO();
cvDTO.MaChucVu = _dt.Rows[index]["MaChucVu"].ToString();
cvDTO.TenChucVu = _dt.Rows[index]["TenChucVu"].ToString();
lstChucVu.Add(cvDTO);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(lstChucVu);
}
private void btnXoa_Click(object sender, EventArgs e)
{
ChucVu_DTO chucVu = new ChucVu_DTO();
if (txtmacv.Text.Equals(""))
{
MessageBox.Show("Mã chức vụ trống dữ liệu");
}
else if (txtmacv.Text.Length > 5)
{
MessageBox.Show("Mã chức vụ không tồn tại");
}
else
{
chucVu.Macv = txtmacv.Text;
if (chucVu_BUL.deleteChucVu(chucVu))
{
MessageBox.Show("Xóa thành công");
}
else
{
MessageBox.Show("Xóa không thành công");
}
}
hienthi();
}
public ChucVu_DTO GetChucVuByMaCV(string maCV)
{
ChucVu_DTO chucvu = null;
string query = "select * from ChucVu where MaCV=N'" + maCV + "'";
DataTable data = DataProvider.Instace.ExcuteQuey(query);
foreach (DataRow item in data.Rows)
{
chucvu = new ChucVu_DTO(item);
return(chucvu);
}
return(chucvu);
}
public List <ChucVu_DTO> GetListChucVu()
{
List <ChucVu_DTO> listChucVu = new List <ChucVu_DTO>();
string query = "select * from ChucVu";
DataTable data = DataProvider.Instace.ExcuteQuey(query);
foreach (DataRow item in data.Rows)
{
ChucVu_DTO chucvu = new ChucVu_DTO(item);
listChucVu.Add(chucvu);
}
return(listChucVu);
}
public List <ChucVu_DTO> HienThiDanhSachChucVu() //Lấy danh sách ChucVu
{
List <ChucVu_DTO> list = new List <ChucVu_DTO>();
string query = string.Format("Select * from tbl_ChucVu order by MaChucVu");
System.Data.DataTable data = DataProVider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
ChucVu_DTO dssp = new ChucVu_DTO(item);
list.Add(dssp);
}
return(list);
}
public List <ChucVu_DTO> TimKiemTheoTenChucVu(string TenChucVu)
{
List <ChucVu_DTO> list = new List <ChucVu_DTO>();
string query = string.Format("SELECT * FROM tbl_ChucVu WHERE dbo.TimKiem(ChucVu) LIKE N'%' + dbo.TimKiem(N'{0}') + '%'", TenChucVu);
DataTable table = DataProVider.Instance.ExecuteQuery(query);
foreach (DataRow item in table.Rows)
{
ChucVu_DTO TDV = new ChucVu_DTO(item);
list.Add(TDV);
}
return(list);
}
//
private List <ChucVu_DTO> LoadDepartmentaData()
{
//SqlCommand reader = new SqlCommand("SELECT * From CHUCVU", con);
SqlDataReader reader = new SqlCommand("SELECT * From CHUCVU", con);
List <ChucVu_DTO> list = new List <ChucVu_DTO>();
con.Open();
reader.ExecuteReader();
while (reader.Read())
{
ChucVu_DTO cvDTO = new ChucVu_DTO();
cvDTO.StrMaCV = reader.ToString();
cvDTO.StrTenCV = reader.ToString();
}
}
private void txbMaNV_TextChanged(object sender, EventArgs e)
{
string maNV = txbMaNV.Text;
if (maNV != (string)dgvThongTinNV.SelectedCells[0].OwningRow.Cells["Mã NV"].Value)
{
txbTenNV.Clear();
txbDiaChi.Clear();
txbSoDT.Clear();
txbUser.Clear();
txbDisplayName.Clear();
return;
}
if (dgvThongTinNV.SelectedCells.Count > 0)
{
string maCV = (string)dgvThongTinNV.SelectedCells[0].OwningRow.Cells["Chức Vụ"].Value;
string trangThaiNV = (string)dgvThongTinNV.SelectedCells[0].OwningRow.Cells["Trạng Thái"].Value;
if (trangThaiNV == "Đã Nghỉ Việc")
{
txbUser.Text = "Đã nghỉ việc";
txbDisplayName.Text = "Đã nghỉ việc";
return;
}
else
{
txbUser.Text = Account_DAO.Instance.GetAccountByMaNV(maNV).TenDangNhap;
txbDisplayName.Text = Account_DAO.Instance.GetAccountByMaNV(maNV).TenHienThi;
}
ChucVu_DTO chucvu = ChucVu_DAO.Instance.GetChucVuByMaCV(maCV);
comChucVu.SelectedItem = chucvu;
int index = -1;
int i = 0;
if (maCV == null)
{
return;
}
foreach (ChucVu_DTO item in comChucVu.Items)
{
if (item.MaCV == chucvu.MaCV)
{
index = i;
break;
}
i++;
}
comChucVu.SelectedIndex = index;
}
}
public static int ThemChucVu(ChucVu_DTO cvDTO)
{
int count = 0;
try
{
string strTruyVan = string.Format("INSERT INTO ChucVu(MaChucVu,TenChucVu) VALUES('{0}',N'{1}')", cvDTO.MaChucVu, cvDTO.TenChucVu);
count = DataProvider.ExecuteNonQuery(strTruyVan);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(count);
}
public static int CapNhatChucVu(ChucVu_DTO cvDTO)
{
int count = 0;
try
{
string strTruyVan = string.Format("UPDATE ChucVu SET TenChucVu = N'{0}' WHERE MaChucVu = '{1}'", cvDTO.TenChucVu, cvDTO.MaChucVu);
count = DataProvider.ExecuteNonQuery(strTruyVan);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(count);
}
private void btnThemChucVu_Click(object sender, EventArgs e)
{
ChucVu_DTO cvDTO = new ChucVu_DTO();
string errorS = "";
if (txtMaChucVu.Text.Trim() != "")
{
if (ChucVu_BLL.KiemTraMa(txtMaChucVu.Text) == 1)
{
errorS += "Mã chức vụ bị trùng!!!\n";
}
else
{
cvDTO.MaChucVu = txtMaChucVu.Text;
}
}
else
{
errorS += "Chưa nhập mã chức vụ!!\n";
}
if (txtTenChucVu.Text.Trim() != "")
{
cvDTO.TenChucVu = txtTenChucVu.Text;
}
else
{
errorS += "Chưa nhập tên chức vụ!!\n";
}
if (errorS != "")
{
XtraMessageBox.Show(errorS, "Thông báo lỗi");
return;
}
if (ChucVu_BLL.ThemChucVu(cvDTO) == 1)
{
lstChucVu.Add(cvDTO);
HienThiLaiDuLieuTrenGridView();
XtraMessageBox.Show("Thêm 1 chức vụ thành công", "Thông báo");
}
else
{
XtraMessageBox.Show("Thêm 1 chức vụ thất bại", "Thông báo");
return;
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtmacv.Text.Equals(""))
{
MessageBox.Show("Mã chức vụ trống dữ liệu");
}
else if (txtmacv.Text.Length > 5)
{
MessageBox.Show("Mã chức vụ không dài quá 5 ký tự");
}
else if (txttencv.Text.Equals(""))
{
MessageBox.Show("Tên chức vụ trống dữ liệu");
}
else if (txttencv.Text.Length > 20)
{
MessageBox.Show("Tên chức vụ không dài quá 20 ký tự");
}
else if (txthesopc.Text.Equals(""))
{
MessageBox.Show("Hệ số phụ cấp trống dữ liệu");
}
else
{
try
{
ChucVu_DTO chucVu = new ChucVu_DTO();
chucVu.Macv = txtmacv.Text;
chucVu.Tencv = txttencv.Text;
chucVu.Hesopc = float.Parse(txthesopc.Text);
if (chucVu_BUL.updateChucVu(chucVu))
{
MessageBox.Show("Sửa thành công");
}
else
{
MessageBox.Show("Sửa không thành công");
}
}
catch (FormatException)
{
MessageBox.Show("Hệ số phụ cấp sai định dạng");
}
}
hienthi();
}
private void frm_bcNhanVien_Load(object sender, EventArgs e)
{
//report viewer
NhanVien_DTOBindingSource.DataSource = NhanVien_BUS.LayDSNhanVien();
this.reportViewer1.RefreshReport();
//combobox chức vụ
List <ChucVu_DTO> lst = ChucVu_BUS.LayChucVu();
cboChucVu.DataSource = lst;
ChucVu_DTO d = new ChucVu_DTO();
d.SMaCV = "TC";
d.STenCV = "Tất cả";
lst.Insert(0, d);
cboChucVu.ValueMember = "SMaCV";
cboChucVu.DisplayMember = "STenCV";
}
public int themChucVu(ChucVu_DTO cv)
{
int check = kiemTraTonTai(cv.MaCV);
if (check > 0)
{
return(0);
}
else
{
CHUCVU6 themcv = new CHUCVU6
{
MACV = cv.MaCV,
TENCV = cv.TenCV,
HESOPC = cv.HeSoPhuCap
};
db.CHUCVU6s.InsertOnSubmit(themcv);
db.SubmitChanges();
return(1);
}
}
public Boolean deleteChucVu(ChucVu_DTO c)
{
String sql = "DELETE FROM chucvu WHERE macv = @macv";
try
{
SqlConnection conn = getConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@macv", c.Macv);
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException)
{
}
return(false);
}
private void btnCapNhatChucVu_Click(object sender, EventArgs e)
{
btnCapNhatChucVu.Enabled = false;
ChucVu_DTO cvDTO = new ChucVu_DTO();
cvDTO.MaChucVu = txtMaChucVu.Text;
cvDTO.TenChucVu = txtTenChucVu.Text;
if (ChucVu_BLL.CapNhatChucVu(cvDTO) == 1)
{
//ChucVu_DTO cvDTOUpdate = lstChucVu.Single(n => n.MaChucVu == cvDTO.MaChucVu);
//cvDTOUpdate.MaChucVu = cvDTO.MaChucVu;
//cvDTOUpdate.TenChucVu = cvDTO.TenChucVu;
//HienThiLaiDuLieuTrenGridView();
HienThiDanhSachChucVu(pos);
XtraMessageBox.Show("Cập nhật chức vụ thành công", "Thông báo");
}
else
{
XtraMessageBox.Show("Cập nhật chức vụ thất bại", "Thông báo");
return;
}
}
public List <ChucVu_DTO> LoadDSChucVu()
{
List <ChucVu_DTO> lsChucVu = new List <ChucVu_DTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
string strTruyVan = "SELECT * FROM ChucVu WHERE TrangThai = 1";
SqlDataReader reader = DataProvider.TruyVanDuLieu(strTruyVan, conn);
while (reader.Read())
{
ChucVu_DTO chucvu = new ChucVu_DTO()
{
MaCV = reader["MaCV"].ToString(),
TenCV = reader["TenCV"].ToString(),
TrangThai = int.Parse(reader["TrangThai"].ToString())
};
lsChucVu.Add(chucvu);
}
reader.Close();
conn.Close();
return(lsChucVu);
}
public static List <ChucVu_DTO> LoadChucVu()
{
string strTruyVan = "SELECT * FROM CHUCVU";
con = DataProvider.MoKetNoi();
DataTable dt = DataProvider.LayDataTable(strTruyVan, con);
if (dt.Rows.Count == 0)
{
return(null);
}
List <ChucVu_DTO> listcv = new List <ChucVu_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ChucVu_DTO cv = new ChucVu_DTO();
cv.StrMaCV = dt.Rows[i]["MA_CV"].ToString();
cv.StrTenCV = dt.Rows[i]["TEN_CV"].ToString();
listcv.Add(cv);
}
DataProvider.DongKetNoi(con);
return(listcv);
}
public Boolean insertChucVu(ChucVu_DTO c)
{
String sql = "INSERT INTO chucvu VALUES (@macv, @tencv, @hesopc)";
try
{
SqlConnection conn = getConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@macv", c.Macv);
cmd.Parameters.AddWithValue("@tencv", c.Tencv);
cmd.Parameters.AddWithValue("@hesopc", c.Hesopc);
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException)
{
}
return(false);
}
public Boolean updateChucVu(ChucVu_DTO c)
{
String sql = "UPDATE chucvu SET tencv = @tencv, hesopc = @hesopc WHERE macv = @macv";
try
{
SqlConnection conn = getConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@tencv", c.Tencv);
cmd.Parameters.AddWithValue("@hesopc", c.Hesopc);
cmd.Parameters.AddWithValue("@macv", c.Macv);
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException)
{
}
return(false);
}
public static List <ChucVu_DTO> LayChucVu()
{
string sTruyVan = "select * from chucvu";
con = DataProvider.MoKetNoi();
DataTable dt = DataProvider.TruyVanLayDuLieu(sTruyVan, con);
if (dt.Rows.Count == 0)
{
return(null);
}
List <ChucVu_DTO> lstChucVu = new List <ChucVu_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ChucVu_DTO cv = new ChucVu_DTO();
cv.SMaCV = dt.Rows[i]["macv"].ToString();
cv.STenCV = dt.Rows[i]["tencv"].ToString();
cv.FHSPhuCap = float.Parse(dt.Rows[i]["hsphucap"].ToString());
lstChucVu.Add(cv);
}
DataProvider.DongKetNoi(con);
return(lstChucVu);
}
public Boolean insertChucVu(ChucVu_DTO c)
{
return(cv.insertChucVu(c));
}
public Boolean updateChucVu(ChucVu_DTO c)
{
return(cv.updateChucVu(c));
}
public Boolean deleteChucVu(ChucVu_DTO c)
{
return(cv.deleteChucVu(c));
}
public int themChucVu_BUS(GunaTextBox txtMa, GunaTextBox txtTen, GunaTextBox hspc)
{
ChucVu_DTO cv = new ChucVu_DTO(txtMa.Text.ToUpper(), txtTen.Text.ToUpper(), Single.Parse(hspc.Text));
return(ChucVu_DAO.createInstance.themChucVu(cv));
}
public static int ThemChucVu(ChucVu_DTO cvDTO) => ChucVu_DAL.ThemChucVu(cvDTO);
public static int CapNhatChucVu(ChucVu_DTO cvDTO) => ChucVu_DAL.CapNhatChucVu(cvDTO);
