/// <summary>
/// thu tuc sua thong tin bang khen thuong ky luat
/// </summary>
/// <param name="khenThuongKyLuat"></param>
public void ExcuteProc(KhenThuongKyLuat khenThuongKyLuat)
{
//SqlConnection conn = DBUtils.GetDBConnection();
SqlConnection conn = new SqlConnection("Server=DEVSERVER-WIN7\\SQLEXPRESS;Database=ThucTapNhom_QuanLyNhanSu;Integrated Security=true");
// conn.ConnectionString = "Server=DEVSERVER-WIN7\\SQLEXPRESS;Database=ThucTapNhom_QuanLyNhanSu;Integrated Security=true";
//Trusted_Connection=true";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("EditKhenThuongKyLuat", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maChucVuCu", SqlDbType.Char, 10)).Value = this.MaNhanVienCu;
cmd.Parameters.Add(new SqlParameter("@soQuyetDinhCu", SqlDbType.Char, 10)).Value = this.SoQuyetDinhCu;
cmd.Parameters.Add(new SqlParameter("@maChucVu", SqlDbType.Char, 10)).Value = khenThuongKyLuat.MaNhanVien;
cmd.Parameters.Add(new SqlParameter("@soQuyetDinh", SqlDbType.Char, 10)).Value = khenThuongKyLuat.SoQuyetDinh;
cmd.Parameters.Add(new SqlParameter("@thoiGian", SqlDbType.Date)).Value = khenThuongKyLuat.ThoiGian.ToString("yyyy-MM-dd HH:mm:SS");
//excute proc
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
}
public ActionResult Sua(KhenThuongKyLuat k, int id)
{
if (ModelState.IsValid)
{
db.Entry(k).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("KhenThuongKyLuat"));
}
return(View(k));
}
public ActionResult Them(KhenThuongKyLuat k)
{
if (ModelState.IsValid)
{
db.KhenThuongKyLuats.Add(k);
db.SaveChanges();
return(RedirectToAction("KhenThuongKyLuat"));
}
//ViewBag.MaNhanVien = new SelectList(db.NhanViens, "MaNhanVien", "FirstName", k.MaNhanVien);
return(View(k));
}
public KhenThuongKyLuat Layktkltheoma(string MaPH)
{
DataTable dt = KTDAL.LayKTKLTheoMa(MaPH);
KhenThuongKyLuat kt = new KhenThuongKyLuat();
kt.Manphieu = dt.Rows[0][0].ToString();
kt.Tenphieu = dt.Rows[0][1].ToString();
kt.Masinhvien = dt.Rows[0][2].ToString();
kt.Noidung = dt.Rows[0][3].ToString();
kt.Hinhthuc = dt.Rows[0][4].ToString();
kt.Ngaylap = dt.Rows[0][5].ToString();
kt.Manhanvien = dt.Rows[0][6].ToString();
kt.Ghichu = dt.Rows[0][7].ToString();
return(kt);
}
public void EditKhenThuongKyLuat(KhenThuongKyLuat khenThuongKyLuat)
{
try
{
openConnection();
string query = "update KHENTHUONG_KYLUAT set SoQD = @soqd, ThoiGian = @thoigian where MaNV = @manv";
SqlCommand cmd = new SqlCommand(query, Conn);
cmd.Parameters.AddWithValue("@manv", khenThuongKyLuat.MaNhanVien);
cmd.Parameters.AddWithValue("@soqd", khenThuongKyLuat.SoQuyetDinh);
cmd.Parameters.AddWithValue("@thoigian", khenThuongKyLuat.ThoiGian);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw;
}
finally
{
closeConnection();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
lockControl();
KhenThuongKyLuat khenThuongKyLuat = new KhenThuongKyLuat(txtMaNV.Text, txtSoQDKhenThuongKyLuat.Text, dtThoiGian.Value);
if (kt == true)
{
if (txtMaNV.Text == null || txtSoQDKhenThuongKyLuat.Text == null)
{
MessageBox.Show("Bạn chưa điền đủ thông tin!");
}
else
{
try
{
addKhenThuong_KyLuat.AddProc(khenThuongKyLuat);
MessageBox.Show("Lưu Thông tin Thành công!");
}
catch (Exception)
{
MessageBox.Show("Thêm thông tin không thành công!", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
//try
//{
// editThongTinKhenThuongKyLuat.ExcuteProc(khenThuongKyLuat);
//}
//catch (Exception)
//{
// MessageBox.Show("Sửa thông tin khen thưởng kỷ luật không thành công", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
KhenThuongKyLuat_Controller khenThuongKyLuat_Controller = new KhenThuongKyLuat_Controller();
khenThuongKyLuat_Controller.EditKhenThuongKyLuat(khenThuongKyLuat);
}
loadList();
}
public void AddProc(KhenThuongKyLuat KhenThuongKyLuat)
{
SqlConnection conn = new SqlConnection("Server=.;Database=QuanLyNhanSu;Integrated Security=true");
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into KHENTHUONG_KYLUAT(MaNV, SoQD, ThoiGian) values (@MaNV, @SoQD, @ThoiGian)", conn);
cmd.Parameters.Add(new SqlParameter("@MaNV", SqlDbType.Char, 10)).Value = KhenThuongKyLuat.MaNhanVien;
cmd.Parameters.Add(new SqlParameter("@SoQD", SqlDbType.Char, 10)).Value = KhenThuongKyLuat.SoQuyetDinh;
cmd.Parameters.Add(new SqlParameter("@ThoiGian", SqlDbType.Date)).Value = KhenThuongKyLuat.ThoiGian;
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
}
public void XoaKTKL(string MaPH)
{
KT = new KhenThuongKyLuat(MaPH, "", "", "", "", "", "", "");
KTDAL.Xoaktkl(KT);
}
public void SuaKTKL(string maphieu, string tenphieu, string masv, string noidung, string hinhthuc, string ngaylap, string manv, string ghichu)
{
KT = new KhenThuongKyLuat(maphieu, tenphieu, masv, noidung, hinhthuc, ngaylap, manv, ghichu);
KTDAL.Suaktkl(KT);
}
public void Xoaktkl(KhenThuongKyLuat kt)
{
strSQL = "Delete KhenThuongKyLuat where MaPhieu='" + kt.Manphieu + "'";
helper.ThucThiKN(strSQL);
}
public void Suaktkl(KhenThuongKyLuat kt)
{
strSQL = "Update KhenThuongKyLuat set MaPhieu='" + kt.Manphieu + "',TenPhieu=N'" + kt.Tenphieu + "',MaSV='" + kt.Masinhvien + "',NoiDung=N'" + kt.Noidung + "',HinhThuc=N'" + kt.Hinhthuc + "',MaNV='" + kt.Manhanvien + "',GhiChu=N'" + kt.Ghichu + "' where MaPhieu='" + kt.Manphieu + "'";
helper.ThucThiKN(strSQL);
}
public void Themktkl(KhenThuongKyLuat kt)
{
strSQL = "Insert into KhenThuongKyLuat values('" + kt.Manphieu + "',N'" + kt.Tenphieu + "','" + kt.Masinhvien + "',N'" + kt.Noidung + "',N'" + kt.Hinhthuc + "','" + kt.Ngaylap + "','" + kt.Manhanvien + "',N'" + kt.Ghichu + "' )";
helper.ThucThiKN(strSQL);
}
