public static void UpdateData(int Id, string Name, string control, string icon, string active, int menuparent) { PenjaminanDatasetTableAdapters.tPageTableAdapter ta = new PenjaminanDatasetTableAdapters.tPageTableAdapter(); PenjaminanDataset.tPageDataTable dt = ta.GetDataByID(Id); try { if (dt != null) { dt[0].name = Name; dt[0].control = control; dt[0].icon = icon; dt[0].active = active; dt[0].menuparent = menuparent; dt[0].creby = "1"; dt[0].credate = DateTime.Now; ta.Update(dt); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static void SoftDeleteData(int id) { PenjaminanDatasetTableAdapters.tPageTableAdapter ta = new PenjaminanDatasetTableAdapters.tPageTableAdapter(); PenjaminanDataset.tPageDataTable dt = ta.GetDataByID(id); try { if (dt != null) { dt[0].deleted = "1"; ta.Update(dt); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static PenjaminanDataset.tPageRow SelectByName(string Nama) { PenjaminanDatasetTableAdapters.tPageTableAdapter ta = new PenjaminanDatasetTableAdapters.tPageTableAdapter(); PenjaminanDataset.tPageDataTable dt = new PenjaminanDataset.tPageDataTable(); PenjaminanDataset.tPageRow dr = null; try { ta.FillByName(dt, Nama); if (dt.Count > 0) { dr = dt[0]; } return(dr); } catch (Exception ex) { throw new ApplicationException("Failed to load Employee data : " + ex.Message); } }