public List <Entity.Absensi> ReadByName(string nama)
{
List <Entity.Absensi> list = new List <Entity.Absensi>();
try
{
string sql = @"select ID, absensi.Id_karyawan, karyawan.Nm_karyawan, absensi.Tanggal, absensi.Jam_masuk from absensi inner join karyawan on absensi.Id_karyawan=karyawan.Id_karyawan where Nm_karyawan like @nama or absensi.Id_karyawan like @Id_karyawan ";
using (OleDbCommand cmd = new OleDbCommand(sql, _conn))
{
cmd.Parameters.AddWithValue("@nama", "%" + nama + "%");
cmd.Parameters.AddWithValue("@Id_karyawan", "%" + nama + "%");
MessageBox.Show("gunawan");
using (OleDbDataReader dtr = cmd.ExecuteReader())
{
while (dtr.Read())
{
MessageBox.Show("gunawan ada");
Entity.Absensi absen = new Entity.Absensi();
absen.Id = Convert.ToInt32(dtr["ID"].ToString());
absen.Id_karyawan = Convert.ToInt32(dtr["Id_karyawan"].ToString());
absen.Nm_krywn = dtr["Nm_karyawan"].ToString();
absen.Tanggal = Convert.ToDateTime(dtr["Tanggal"].ToString());
absen.Jam_masuk = Convert.ToDateTime(dtr["Jam_masuk"].ToString());
list.Add(absen);
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print("Create error: {0}", ex.Message);
}
return(list);
}
public List <Entity.Absensi> ReadAll()
{
List <Entity.Absensi> list = new List <Entity.Absensi>();
try
{
string sql = @"select ID, absensi.Id_karyawan, karyawan.Nm_karyawan, absensi.Tanggal, absensi.Jam_masuk from absensi inner join karyawan on absensi.Id_karyawan=karyawan.Id_karyawan order by absensi.Jam_masuk";
using (OleDbCommand cmd = new OleDbCommand(sql, _conn))
{
using (OleDbDataReader dtr = cmd.ExecuteReader())
{
while (dtr.Read())
{
Entity.Absensi absen = new Entity.Absensi();
absen.Id = Convert.ToInt32(dtr["ID"].ToString());
absen.Id_karyawan = Convert.ToInt32(dtr["Id_karyawan"].ToString());
absen.Nm_krywn = dtr["Nm_karyawan"].ToString();
absen.Tanggal = Convert.ToDateTime(dtr["Tanggal"].ToString());
absen.Jam_masuk = Convert.ToDateTime(dtr["Jam_masuk"].ToString());
list.Add(absen);
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print("Create error: {0}", ex.Message);
}
return(list);
}
public int Create(Entity.Absensi absen)
{
int result = 0;
string sql = @"insert into absensi (Id_karyawan, Tanggal, Jam_masuk) values ('" + absen.Id_karyawan + "', '" + absen.Tanggal + "', '" + absen.Jam_masuk + "')";
using (OleDbCommand cmd = new OleDbCommand(sql, _conn))
{
try
{
result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print("Create error: {0}", ex.Message);
}
}
return(result);
}
public int delete(Entity.Absensi absen)
{
int result = 0;
string sql = @"delete from absensi where ID = @Id";
using (OleDbCommand cmd = new OleDbCommand(sql, _conn))
{
cmd.Parameters.AddWithValue("@Id", absen.Id);
try
{
result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print("Delete error: {0}", ex.Message);
}
}
return(result);
}
