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); }