public static void InsertData(string Name) { PenjaminanDatasetTableAdapters.DivisiTableAdapter ta = new PenjaminanDatasetTableAdapters.DivisiTableAdapter(); try { ta.Insert(Name); } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static void Delete(int id) { PenjaminanDatasetTableAdapters.DivisiTableAdapter ta = new PenjaminanDatasetTableAdapters.DivisiTableAdapter(); PenjaminanDataset.DivisiDataTable dt = ta.GetDataByID(id); try { if (dt != null) { dt[0].Delete(); ta.Update(dt); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static void UpdateData(int Id, string NamaDivisi) { PenjaminanDatasetTableAdapters.DivisiTableAdapter ta = new PenjaminanDatasetTableAdapters.DivisiTableAdapter(); PenjaminanDataset.DivisiDataTable dt = ta.GetDataByID(Id); try { if (dt != null) { //dt[0].ID = Id; dt[0].NamaDivisi = NamaDivisi; ta.Update(dt); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static PenjaminanDataset.DivisiRow selectDivisiByID(int id) { PenjaminanDatasetTableAdapters.DivisiTableAdapter ta = new PenjaminanDatasetTableAdapters.DivisiTableAdapter(); PenjaminanDataset.DivisiDataTable dt = new PenjaminanDataset.DivisiDataTable(); PenjaminanDataset.DivisiRow dr = null; try { ta.FillByID(dt, id); if (dt.Count > 0) { dr = dt[0]; } return(dr); } catch (Exception ex) { throw new ApplicationException("Failed to load Divisi data : " + ex.Message); } }
public static PenjaminanDataset.DivisiRow selectIDByNamaDivisi(string Nama) { PenjaminanDatasetTableAdapters.DivisiTableAdapter ta = new PenjaminanDatasetTableAdapters.DivisiTableAdapter(); PenjaminanDataset.DivisiDataTable dt = new PenjaminanDataset.DivisiDataTable(); PenjaminanDataset.DivisiRow dr = null; try { ta.FillByNamaDivisi(dt, Nama); if (dt.Count > 0) { dr = dt[0]; } return(dr); } catch (Exception ex) { throw new ApplicationException("Failed to load Employee data : " + ex.Message); } }