public static void SoftDeleteData(int id)
{
PenjaminanDatasetTableAdapters.KaryawanTableAdapter ta = new PenjaminanDatasetTableAdapters.KaryawanTableAdapter();
PenjaminanDataset.KaryawanDataTable dt = ta.GetDataByID(id);
try
{
if (dt != null)
{
dt[0].isDelete = true;
ta.Update(dt);
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
public static PenjaminanDataset.KaryawanRow selectKaryawanByID(int id)
{
PenjaminanDatasetTableAdapters.KaryawanTableAdapter ta = new PenjaminanDatasetTableAdapters.KaryawanTableAdapter();
PenjaminanDataset.KaryawanDataTable dt = new PenjaminanDataset.KaryawanDataTable();
PenjaminanDataset.KaryawanRow dr = null;
try
{
ta.FillByjoin(dt, id);
if (dt.Count > 0)
{
dr = dt[0];
}
return(dr);
}
catch (Exception ex)
{
throw new ApplicationException("Failed to load Employee data : " + ex.Message);
}
}
public static void UpdateData(int id, string Name, int divisiID, string alamat)
{
PenjaminanDatasetTableAdapters.KaryawanTableAdapter ta = new PenjaminanDatasetTableAdapters.KaryawanTableAdapter();
PenjaminanDataset.KaryawanDataTable dt = ta.GetDataByID(id);
try
{
if (dt != null)
{
dt[0].Nama = Name;
dt[0].DivisiID = divisiID;
dt[0].Alamat = alamat;
//dt[0].NamaDivisi = NamaDivisi;
ta.Update(dt);
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
