private CongViecDTO checkData()
{
string ma = txtMaCongViec.Text;
string ten = txtTenCongViec.Text;
string z = string.Join("", txtMaCongViec.Text.Where(char.IsDigit));
if (txtMaCongViec.Text.Trim().Length == 0)
{
MessageBox.Show("Bạn Chưa Nhập Mã Công Việc", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMaCongViec.Focus();
return(null);
}
else if (txtTenCongViec.Text.Trim().Length == 0)
{
MessageBox.Show("Bạn Chưa Nhập Tên Công Việc", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtTenCongViec.Focus();
txtTenCongViec.Focus();
return(null);
}
else if (txtMaCongViec.Text.Contains("CV") == false)
{
MessageBox.Show("Nhập Theo Định Dạng Là \"CV\"", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMaCongViec.Focus();
return(null);
}
else if (z == "")
{
MessageBox.Show("Nhập Theo Định Dạng Là \"CV\" và Thêm Số Đằng Sau", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMaCongViec.Focus();
return(null);
}
CongViecDTO dto = new CongViecDTO(ma, Handling.FormHandling.formatString(ten));
return(dto);
}
public static List <CongViecDTO> SelectCongViecByTenCongViec(String tenCV)
{
List <CongViecDTO> list = new List <CongViecDTO>();
try
{
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("@TenCV", tenCV));
DataTable dt = MySqlDataAccessHelper.ExecuteQuery("SELECT * FROM congviec where TenCV = @TenCV", parameters);
foreach (DataRow dr in dt.Rows)
{
CongViecDTO congviec = new CongViecDTO();
congviec.MaCV = dr["MaCV"].ToString();
congviec.TenCV = dr["TenCV"].ToString();
congviec.MoTa = dr["MoTa"].ToString();
list.Add(congviec);
}
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public List <CongViecDTO> GetAllCongViec()
{
List <CongViecDTO> list = new List <CongViecDTO>();
string connectionString = DataAccess.Internal.DataAccess.GetConnectionString("TodoListDb");
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
// Set up a command with the given query and associate
// this with the current connection.
string query = @"select * from CongViec";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
CongViecDTO cv = new CongViecDTO();
cv.Id = Convert.ToInt32(dr[0].ToString());
cv.NgayBatDau = dr[3].ToString();
cv.NgayKetThuc = dr[4].ToString();
cv.PhamVi = (bool)dr["IsPublic"];
cv.Status = Convert.ToInt32(dr["Status"].ToString());
cv.TenCongViec = dr[1].ToString();
cv.BinhLuan = dr[6].ToString();
cv.FileDinhKem = dr[5].ToString();
list.Add(cv);
}
}
}
}
return(list);
}
public List <CongViecDTO> GetAllCongViecNVcv(string idCv, string idNv)
{
List <CongViecDTO> list = new List <CongViecDTO>();
string connectionString = DataAccess.Internal.DataAccess.GetConnectionString("TodoListDb");
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
// Set up a command with the given query and associate
// this with the current connection.
string query = @"select cv.StartDate,cv.EndDate,pc.comment from CongViec cv,PhanCong pc , NhanVien nv"
+ "where nv.id = pc.idnhanvien"
+ "and cv.id = pc.idcongviec"
+ "and nv.id = " + idNv + ""
+ "and cv.id = " + idCv;
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
CongViecDTO cv = new CongViecDTO();
cv.NgayBatDau = dr[0].ToString();
cv.NgayKetThuc = dr[1].ToString();
cv.BinhLuan = dr[2].ToString();
list.Add(cv);
}
}
}
}
return(list);
}
internal List <CongViecDTO> getCongViecById(string v)
{
List <CongViecDTO> list = new List <CongViecDTO>();
string connectionString = DataAccess.Internal.DataAccess.GetConnectionString("TodoListDb");
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
// Set up a command with the given query and associate
// this with the current connection.
string query = @"SELECT cv.id,cv.NameCongViec from CongViec cv
WHERE cv.id not in (SELECT idcongviec from PhanCong WHERE IdNhanVien = " + v + ") ";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
CongViecDTO cv = new CongViecDTO();
cv.Id = Convert.ToInt32(dr["Id"].ToString());
cv.TenCongViec = dr["NameCongViec"].ToString();
list.Add(cv);
}
}
}
}
return(list);
}
public async Task <IActionResult> UpdateCongViec(int id, [FromBody] CongViecDTO congViecDTO)
{
var congViec = congViecDTO.ToEntity();
await _congViecService.UpdateCongViec(congViec);
return(Ok(congViec));
}
public async Task <IActionResult> CreateCongViec(CongViecDTO congViecDTO)
{
var congViec = congViecDTO.ToEntity();
await _congViecService.CreateCongViec(congViec);
return(Ok(congViec));
}
public static CongViec ToCongViec(this CongViecDTO congViecDTO)
{
return(new CongViec()
{
CongViecId = congViecDTO.CongViecId,
TenCongViec = congViecDTO.TenCongViec
});
}
public async Task <IActionResult> GetCongViecById(int id)
{
var congViec = await _congViecService.GetCongViecById(id);
var result = CongViecDTO.FromEntity(congViec);
return(Ok(result));
}
public static void saveCV(CongViecDTO hs, string method)
{
SqlParameter[] sqlP = new SqlParameter[2];
sqlP[0] = new SqlParameter("@MaCV", hs.MaCV1);
sqlP[1] = new SqlParameter("@TenCV", hs.TenCV1);
if (method == sys.INSERT)
{
GenericDAL.execNonQuery("sp_InsertCongViec", sqlP, Conn);
}
else if (method == sys.UPDATE)
{
GenericDAL.execNonQuery("sp_UpdateCongViec", sqlP, Conn);
}
}
/// <summary>
/// tìm theo công viec nhan vien
/// </summary>
/// <param name="cv"></param>
/// <returns></returns>
public static DataTable Search_Congviec_NV(CongViecDTO cv)
{
try
{
DataTable dt = new DataTable();
string search_ten = string.Format("SELECT ma_nv,ten_nv,ngay_sinh,gioi_tinh,sdt_nv,dia_chi_nv,email,db_chucvu.ten_cv FROM db_nhanvien,db_chucvu WHERE db_nhanvien.ma_cv = db_chucvu.ma_cv and db_chucvu.ten_cv='{0}'", cv.ten_cv);
cnn = DataProvider.ConnectData();
MySqlDataAdapter dta = new MySqlDataAdapter(search_ten, cnn);
dta.Fill(dt);
cnn.Close();
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (checkDuplicate() == 2)
{
MessageBox.Show("Không Có Mã Đó Để Thay Đổi Liên Quan", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMaCongViec.Text = "";
return;
}
else
{
CongViecDTO ob = checkData();
if (ob != null)
{
B_CongViec.saveCV(ob, sys.UPDATE);
MessageBox.Show("Sửa Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
dt = B_CongViec.GetAllCV();
dgvCongViec.DataSource = dt;
clearTxt();
}
}
}
public static List <CongViecDTO> SelectCongViecAll()
{
List <CongViecDTO> list = new List <CongViecDTO>();
try
{
DataTable dt = MySqlDataAccessHelper.ExecuteQuery("SELECT * FROM congviec");
foreach (DataRow dr in dt.Rows)
{
CongViecDTO congviec = new CongViecDTO();
congviec.MaCV = dr["MaCV"].ToString();
congviec.TenCV = dr["TenCV"].ToString();
congviec.MoTa = dr["MoTa"].ToString();
list.Add(congviec);
}
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
private void btnThem_Click(object sender, EventArgs e)
{
CongViecDTO ob = checkData();
if (ob != null)
{
if (checkDuplicate() == 1)
{
MessageBox.Show("Mã Công Việc Trùng", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMaCongViec.Focus();
return;
}
else
{
B_CongViec.saveCV(ob, sys.INSERT);
MessageBox.Show("Thêm Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
dt = B_CongViec.GetAllCV();
dgvCongViec.DataSource = dt;
clearTxt();
}
}
}
public static void saveCV(CongViecDTO hs, string method)
{
D_CongViec.saveCV(hs, method);
}
public string Add(CongViecDTO obj)
{
return(congViecAc.Add(obj.ToCongViec()));
}
public static DataTable Search_tenCV(CongViecDTO cv)
{
return(NhanVienDAO.Search_Congviec_NV(cv));
}
public string Remove(CongViecDTO obj)
{
return(congViecAc.Remove(obj.ToCongViec()));
}
public string Update(CongViecDTO obj)
{
return(congViecAc.Update(obj.ToCongViec()));
}
