public static void Delete(int fkMitra) { PenjaminanDatasetTableAdapters.m_bod2TableAdapter taX = new PenjaminanDatasetTableAdapters.m_bod2TableAdapter(); PenjaminanDatasetTableAdapters.m_bodTableAdapter ta = new PenjaminanDatasetTableAdapters.m_bodTableAdapter(); PenjaminanDataset.m_bod2DataTable dt = taX.GetDataforDelete(Convert.ToDecimal(fkMitra)); try { if (dt != null) { ta.softDelete("1", fkMitra); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static void insertData(List <Object.BoardOfDirector> b, int idMitra) { PenjaminanDatasetTableAdapters.m_bodTableAdapter ta = new PenjaminanDatasetTableAdapters.m_bodTableAdapter(); foreach (var data in b) { try { if (data.id != 0) { int newID = data.id; PenjaminanDatasetTableAdapters.m_bod2TableAdapter taX = new PenjaminanDatasetTableAdapters.m_bod2TableAdapter(); PenjaminanDataset.m_bod2DataTable dt = taX.GetDataByID(newID); try { if (dt != null) { dt[0].name = data.name; dt[0].jabatan = data.jabatan; dt[0].lastupdatedby = 2; dt[0].lastupdateddate = DateTime.Now; taX.UpdateQuery(data.tglLahir, DateTime.Now, 2, data.jabatan, data.name, data.id); idMitra = data.fk_mitra; } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } } else { ta.Insert(idMitra, data.name, data.jabatan, 1, DateTime.Now, 1, DateTime.Now, "0", data.tglLahir); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } } }