public Boolean LuuDong(DOBangChamCong dto)
{
string sql = "update BANG_CHAM_CONG set SANG = @SANG, CHIEU = @CHIEU where NV_ID = @NV_ID and NGAY = @NGAY";
DatabaseFB db = HelpDB.getDatabase();
DbCommand cmd = db.GetSQLStringCommand(sql);
db.AddInParameter(cmd, "@NV_ID", DbType.Int64, dto.NV_ID);
db.AddInParameter(cmd, "@NGAY", DbType.DateTime, dto.NGAY);
db.AddInParameter(cmd, "@SANG", DbType.String, dto.SANG);
db.AddInParameter(cmd, "@CHIEU", DbType.String, dto.CHIEU);
if (db.ExecuteNonQuery(cmd) > 0)
return true;
return false;
}
void rep_xoa_Click(object sender, EventArgs e)
{
if (HelpMsgBox.ShowConfirmMessage("Bạn có thực sự muốn xóa không ?") == DialogResult.Yes)
{
DataRow dr = gridViewDetails.GetDataRow(gridViewDetails.FocusedRowHandle);
for (int i = 0; i < ChonNgay.Length; i++)
{
DOBangChamCong dto = new DOBangChamCong();
dto.NV_ID = long.Parse(dr["NV_ID"].ToString());
dto.NGAY = ChonNgay[i];
DABangChamCong.Ins.XoaDong(dto);
}
gridViewDetails.DeleteRow(gridViewDetails.FocusedRowHandle);
((DataTable)gridControlDetails.DataSource).AcceptChanges();
barButtonItemAdd.Enabled = true;
}
}
private bool CapNhat()
{
string err = string.Empty;
try
{
DataTable tb = (DataTable)gridControlDetails.DataSource;
for (int i = 0; i < tb.Rows.Count; i++)
{
int sc = 0;
for (int j = 0; j < ChonNgay.Length; j++)
{
DOBangChamCong dto = new DOBangChamCong();
dto.NGAY = ChonNgay[j];
dto.NV_ID = long.Parse(tb.Rows[i]["NV_ID"].ToString());
dto.SANG = tb.Rows[i][sc].ToString();
sc++;
dto.CHIEU = tb.Rows[i][sc].ToString();
sc++;
if (DABangChamCong.Ins.IsTonTai(dto.NV_ID, dto.NGAY))
{
if (dto.SANG.Length > 0 || dto.CHIEU.Length > 0)
DABangChamCong.Ins.LuuDong(dto);
else if (dto.SANG == "" && dto.CHIEU == "")
DABangChamCong.Ins.XoaDong(dto);
}
else
{
if(dto.SANG.Length>0 ||dto.CHIEU.Length>0)
DABangChamCong.Ins.ThemDong(dto);
}
}
}
}
catch (Exception ex)
{
err = ex.Message;
HelpMsgBox.ShowErrorMessage(ex.Message);
}
if (err == string.Empty)
return true;
return false;
}
public void ThemNhanVien()
{
//Xem lại hàm này bên chấm công tự động để sửa lại
DataTable Kq = ((DataTable)gridControlDetails.DataSource);
DataTable NVBoSung = this.LocNhanVien();
if (NVBoSung.Rows.Count > 0)
{
for (int i = 0; i < NVBoSung.Rows.Count; i++)
{
DataRow dr = Kq.NewRow();
dr["NV_ID"] = long.Parse(NVBoSung.Rows[i]["ID"].ToString());
dr["NAME"] = NVBoSung.Rows[i]["NAME"].ToString();
Kq.Rows.Add(dr);
//Ghi xuong csdl
for (int j = 0; j < SoNgayChon; j++)
{
DOBangChamCong dto = new DOBangChamCong();
dto.NV_ID = long.Parse(dr["NV_ID"].ToString());
dto.NGAY = ChonNgay[j];
dto.SANG = "";
dto.CHIEU = "";
dto.THANG_NAM = "";
DABangChamCong.Ins.ThemDong(dto);
}
}
barButtonItemAdd.Enabled = true;
CapNhatThongKe();
}
}
public Boolean ThemDong(DOBangChamCong dto)
{
string sql = "insert into BANG_CHAM_CONG(ID,NV_ID,NGAY,SANG,CHIEU) values(@ID,@NV_ID,@NGAY,@SANG,@CHIEU)";
DatabaseFB db = HelpDB.getDatabase();
DbCommand cmd = db.GetSQLStringCommand(sql);
db.AddInParameter(cmd,"@ID",DbType.Int64, db.GetID("GEN_BANG_CHAM_CONG_ID"));
db.AddInParameter(cmd, "@NV_ID", DbType.Int64, dto.NV_ID);
db.AddInParameter(cmd, "@NGAY", DbType.DateTime, dto.NGAY);
db.AddInParameter(cmd, "@SANG", DbType.String, dto.SANG);
db.AddInParameter(cmd, "@CHIEU", DbType.String, dto.CHIEU);
if (db.ExecuteNonQuery(cmd)> 0)
return true;
return false;
}
public Boolean XoaDong(DOBangChamCong dto)
{
string sql = "delete from BANG_CHAM_CONG where NV_ID = @NV_ID and NGAY = @NGAY";
DatabaseFB db = HelpDB.getDatabase();
DbCommand cmd = db.GetSQLStringCommand(sql);
db.AddInParameter(cmd, "@NV_ID", DbType.Int64, dto.NV_ID);
db.AddInParameter(cmd, "@NGAY", DbType.DateTime, dto.NGAY);
if (db.ExecuteNonQuery(cmd) > 0)
return true;
return false;
}