private void btnLuu_Click(object sender, EventArgs e)
{
if (Them == true)
{
//try
//{
// Thực hiện lệnh
BLPhanCong blTp = new BLPhanCong();
blTp.ThemPC(txtMaNV.Text, txtMaDA.Text, txtNgayBD.Text, txtNgayKT.Text, ref err);
// Load lại dữ liệu trên DataGridView
LoadData();
// Thông báo
MessageBox.Show("Đã thêm xong!");
//}
//catch (SqlException)
//{
// MessageBox.Show("Không thêm được. Lỗi rồi!");
//}
}
else
{
// Thực hiện lệnh
BLPhanCong blTp = new BLPhanCong();
blTp.CapNhatPC(txtMaNV.Text, txtMaDA.Text, txtNgayBD.Text, txtNgayKT.Text, ref err);
// Load lại dữ liệu trên DataGridView
LoadData();
// Thông báo
MessageBox.Show("Đã sửa xong!");
}
}
private void LoadData()
{
List <NhanVien> dsNV = new List <NhanVien>();
blpc = new BLPhanCong();
int k = DateConverttoShiftID(dateTimePicker1.Value);
dspc = blpc.GetDayShift(k * 100 + 1, k * 100 + 3);
for (int i = 0; i < dspc.Tables[0].Rows.Count; i++)
{
DataRow row = dspc.Tables[0].Rows[i];
var x = row.ItemArray.ToList();
NhanVien nv = new NhanVien()
{
MaNV = int.Parse(x[1].ToString()),
HoTen = x[2].ToString(),
GT = true,
CMND = int.Parse(x[0].ToString()),
SDT = 0,
TT_LamViec = true,
MatKhau = "",
QuanLi = 1
};
dsNV.Add(nv);
}
dgvNhanVien.Rows.Clear();
for (int i = 0; i < dsNV.Count; i++)
{
if (dsNV[i].CMND % 100 == 1)
{
dgvNhanVien.Rows.Add("Morning", dsNV[i].MaNV, dsNV[i].HoTen);
}
else if (dsNV[i].CMND % 100 == 2)
{
dgvNhanVien.Rows.Add("Afternoon", dsNV[i].MaNV, dsNV[i].HoTen);
}
else if (dsNV[i].CMND % 100 == 3)
{
dgvNhanVien.Rows.Add("Night", dsNV[i].MaNV, dsNV[i].HoTen);
}
//if(dsNV[i].GT)
// dgvNhanVien.Rows.Add(dsNV[i].MaNV,dsNV[i].HoTen,"Nữ",dsNV[i].CMND,dsNV[i].SDT,dsNV[i].TT_LamViec,dsNV[i].MatKhau,dsNV[i].QuanLi);
//else
// dgvNhanVien.Rows.Add(dsNV[i].MaNV, dsNV[i].HoTen,"Nam", dsNV[i].CMND, dsNV[i].SDT, dsNV[i].TT_LamViec, dsNV[i].MatKhau, dsNV[i].QuanLi);
}
dspc.Clear();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.add)
{
BLPhanCong blpc = new BLPhanCong();
BLNhanVien blnv = new BLNhanVien();
BLCa blca = new BLCa();
CA caa = new CA();
List <CA> dsca = new List <CA>();
List <NHANVIEN> dsnv = new List <NHANVIEN>();
dsnv = blnv.dsNhanVien();
dsca = blca.LoadShift();
NHANVIEN nv = new NHANVIEN();
nv = dsnv.Find(x => (x.MaNV == int.Parse(cbb_emp_ID.SelectedItem.ToString())));
caa = dsca.Find(x => (x.MaCa == int.Parse(cbb_to_shift.SelectedItem.ToString())));
if (blpc.AddPC(nv, caa))
{
MessageBox.Show("SUCCESS!");
}
else
{
MessageBox.Show("FAIL");
}
}
else
{
BLPhanCong blpc = new BLPhanCong();
BLNhanVien blnv = new BLNhanVien();
BLCa blca = new BLCa();
CA TOcaa = new CA();
CA Frcaa = new CA();
List <CA> dsca = new List <CA>();
List <NHANVIEN> dsnv = new List <NHANVIEN>();
dsnv = blnv.dsNhanVien();
dsca = blca.LoadShift();
NHANVIEN nv = new NHANVIEN();
nv = dsnv.Find(x => (x.MaNV == int.Parse(cbb_emp_ID.SelectedItem.ToString())));
TOcaa = dsca.Find(x => (x.MaCa == int.Parse(cbb_to_shift.SelectedItem.ToString())));
Frcaa = dsca.Find(x => (x.MaCa == int.Parse(cbb_shift.SelectedItem.ToString())));
if (blpc.EditPC(nv, Frcaa, TOcaa))
{
MessageBox.Show("SUCCESS!");
}
else
{
MessageBox.Show("FAIL");
}
}
}
private void btn_all_salar_Click(object sender, EventArgs e)
{
blPC = new BLPhanCong();
int heso = 4;
List <int> ListOfOff = new List <int>();
int manv = int.Parse(cbb_empIDs.Text.Trim());
List <PhanCong> pcs = new List <PhanCong>();
for (int i = 0; i < checkedLists_ABS.Count(); i++)
{
foreach (int item in checkedLists_ABS[i].CheckedItems)
{
//ListOfOff.Contains(item);
ListOfOff.Add(item);
}
}
// ListOfOff = checkedLists_ABS[i].CheckedItems.OfType<int>().ToList();
while (ListOfOff.Count != 0)
{
int maCa1 = ListOfOff[0];
int count = 0;
for (int i = 0; i < ListOfOff.Count(); i++)
{
if (ListOfOff[i] == maCa1)
{
count++;
}
}
while (ListOfOff.Contains(maCa1))
{
ListOfOff.Remove(maCa1);
}
PhanCong pc = new PhanCong();
pc.MaNV = manv;
pc.MaCa = maCa1;
pc.HeSo = 4 - count;
if (blPC.Update(pc, out string a))
{
string str = string.Format("MaNV: {0} MaCa: {1} HeSo: {2}", pc.MaNV, pc.MaCa, pc.HeSo);
MessageBox.Show(str);
}
else
{
MessageBox.Show(a);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.add)
{
BLPhanCong blpc = new BLPhanCong();
BLNhanVien blnv = new BLNhanVien();
BLCa blca = new BLCa();
NhanVien nv = new NhanVien();
int manv = int.Parse(cbb_emp_ID.SelectedItem.ToString());
int maca = int.Parse(cbb_to_shift.SelectedItem.ToString());
if (blpc.AddPC(manv, maca, out string err))
{
MessageBox.Show("SUCCESS!");
}
else
{
MessageBox.Show("FAIL ", err);
}
}
else
{
BLPhanCong blpc = new BLPhanCong();
BLNhanVien blnv = new BLNhanVien();
int TOcaa;
int Frcaa;
int nv;
nv = int.Parse(cbb_emp_ID.SelectedItem.ToString());
TOcaa = int.Parse(cbb_to_shift.SelectedItem.ToString());
Frcaa = int.Parse(cbb_shift.SelectedItem.ToString());
if (blpc.Update(nv, Frcaa, TOcaa, out string err))
{
MessageBox.Show("SUCCESS!");
}
else
{
MessageBox.Show(err);
}
}
}
