public static List <PenjaminanDataset.m_pekerjaanRow> selectWDFK(decimal fkBid) { PenjaminanDatasetTableAdapters.m_pekerjaanTableAdapter ta = new PenjaminanDatasetTableAdapters.m_pekerjaanTableAdapter(); PenjaminanDataset.m_pekerjaanDataTable dt = new PenjaminanDataset.m_pekerjaanDataTable(); List <PenjaminanDataset.m_pekerjaanRow> wdList = new List <PenjaminanDataset.m_pekerjaanRow>(); try { ta.SelectWorkDownByFk(dt, fkBid); if (dt.Count > 0) { for (int i = 0; i < dt.Count; i++) { wdList.Add(dt[i]); } } return(wdList); } catch (Exception ex) { throw new ApplicationException("Failed to load Employee data : " + ex.Message); } }
public static void Delete(int id) { PenjaminanDatasetTableAdapters.m_pekerjaanTableAdapter ta = new PenjaminanDatasetTableAdapters.m_pekerjaanTableAdapter(); PenjaminanDataset.m_pekerjaanDataTable dt = ta.GetDataforDelete(Convert.ToDecimal(id)); try { ta.softDelete("1", id); } catch (Exception ex) { throw new ApplicationException("Failed to load Employee data : " + ex.Message); } }
public static void insertData(List <Object.WorkDone2> a, List <Object.WorkProgress> b, int idMitra) { PenjaminanDatasetTableAdapters.m_pekerjaanTableAdapter ta = new PenjaminanDatasetTableAdapters.m_pekerjaanTableAdapter(); foreach (var data in a) { try { if (data.id != 0) { int newID = data.id; PenjaminanDatasetTableAdapters.m_pekerjaanTableAdapter taX = new PenjaminanDatasetTableAdapters.m_pekerjaanTableAdapter(); PenjaminanDataset.m_pekerjaanDataTable dt = taX.GetDataPekerjaanByID(newID); try { if (dt != null) { dt[0].namapaket = data.namapaket; dt[0].lokasi = data.lokasi; dt[0].tanggalpelaksanaan = data.tanggalpelaksanaan; dt[0].tanggalserah = data.tanggalserah; dt[0].nilai = data.nilai; dt[0].lastupdatedby = 2; dt[0].lastupdateddate = DateTime.Now; ta.Update(dt); idMitra = data.fk_mitra; } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } } else { ta.Insert(idMitra, data.tipe, data.namapaket, data.lokasi, data.tanggalpelaksanaan, data.nilai, data.tanggalserah, 1, DateTime.Now, 1, DateTime.Now, "0"); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } } foreach (var data in b) { try { if (data.id != 0) { int newID = data.id; PenjaminanDatasetTableAdapters.m_pekerjaanTableAdapter taX = new PenjaminanDatasetTableAdapters.m_pekerjaanTableAdapter(); PenjaminanDataset.m_pekerjaanDataTable dt = taX.GetDataPekerjaanByID(newID); try { if (dt != null) { dt[0].namapaket = data.namapaket; dt[0].lokasi = data.lokasi; dt[0].tanggalpelaksanaan = data.tanggalpelaksanaan; dt[0].tanggalserah = data.tanggalserah; dt[0].nilai = data.nilai; dt[0].lastupdatedby = 2; dt[0].lastupdateddate = DateTime.Now; ta.Update(dt); idMitra = data.fk_mitra; } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } } else { ta.Insert(idMitra, data.tipe, data.namapaket, data.lokasi, data.tanggalpelaksanaan, data.nilai, data.tanggalserah, 1, DateTime.Now, 1, DateTime.Now, "0"); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } } }