public static void Delete(int fkMitra) { PenjaminanDatasetTableAdapters.t_bidangusahaTableAdapter taX = new PenjaminanDatasetTableAdapters.t_bidangusahaTableAdapter(); PenjaminanDataset.t_bidangusahaDataTable dt = taX.GetForDelete(fkMitra); try { taX.softDelete(1, fkMitra); } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static void insertData(List <Object.t_bidangusaha> b, int idMitra) { PenjaminanDatasetTableAdapters.t_bidangusahaTableAdapter ta = new PenjaminanDatasetTableAdapters.t_bidangusahaTableAdapter(); foreach (var data in b) { try { if (data.fk_bidangusaha != 0 && data.id != 0) { int newID = data.id; PenjaminanDatasetTableAdapters.t_bidangusahaTableAdapter taX = new PenjaminanDatasetTableAdapters.t_bidangusahaTableAdapter(); PenjaminanDataset.t_bidangusahaDataTable dt = taX.GetDataByID(newID); try { if (dt != null) { dt[0].fk_bidangusaha = Convert.ToInt32(data.fk_bidangusaha); dt[0].lastupdatedby = 2; dt[0].lastupdateddate = DateTime.Now; ta.Update(dt); idMitra = Convert.ToInt32(data.fk_mitra); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } } else { ta.InsertQuery(data.fk_bidangusaha, idMitra, 1, DateTime.Now, 1, DateTime.Now, 0); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } } }