public static PenjaminanDataset.m_mitraRow GetIDforAll()
{
PenjaminanDatasetTableAdapters.m_mitraTableAdapter ta = new PenjaminanDatasetTableAdapters.m_mitraTableAdapter();
PenjaminanDataset.m_mitraDataTable dt = new PenjaminanDataset.m_mitraDataTable();
PenjaminanDataset.m_mitraRow dr = null;
try
{
ta.FillID(dt);
if (dt.Count > 0)
{
dr = dt[0];
}
return(dr);
}
catch (Exception ex)
{
throw new ApplicationException("Failed to load Mitra data : " + ex.Message);
}
}
public static PenjaminanDataset.m_mitraRow selectMitraByID(int id)
{
PenjaminanDatasetTableAdapters.m_mitraTableAdapter ta = new PenjaminanDatasetTableAdapters.m_mitraTableAdapter();
PenjaminanDataset.m_mitraDataTable dt = new PenjaminanDataset.m_mitraDataTable();
PenjaminanDataset.m_mitraRow dr = null;
try
{
ta.FillMitraByID(dt, id);
if (dt.Count > 0)
{
dr = dt[0];
}
return(dr);
}
catch (Exception ex)
{
throw new ApplicationException("Failed to load Employee data : " + ex.Message);
}
}
public void bindData(int id)
{
if (Session["tMitra"] == null || Session["tBidangUsahaList"] == null || Session["tWorkDoneList"] == null || Session["tWorkProgressList"] == null || Session["tPicList"] == null || Session["documentDt"] == null || Session["tPemegangSahamList"] == null || Session["tBodList"] == null)
{
//ambil data mitra sesuai id
PenjaminanDataset.m_mitraRow dr = m_mitra.selectMitraByID(id);
List <Object.m_mitra> mitraLIst = new List <Object.m_mitra>();
Object.m_mitra mitra = new Object.m_mitra();
txtCalonMitra.Value = dr.name;
mitra.name = dr.name;
txtLatarBelakang.Value = dr.latarbelakang;
mitra.name = dr.latarbelakang;
mitra.status = dr.status;
if (mitra.status == "E")
{
txtStatusE.Checked = true;
}
else
{
txtStatusB.Checked = true;
}
Session.Remove("tMitra");
Session["tMitra"] = mitraLIst;
//ambil buat bidang usaha
var bidList = t_bidangusaha.selectByFK(eID);
List <Object.t_bidangusaha> bidList1 = new List <Object.t_bidangusaha>();
foreach (var a in bidList)
{
Object.t_bidangusaha bid = new Object.t_bidangusaha();
bid.fk_bidangusaha = Convert.ToDecimal(a.fk_bidangusaha);
bid.name_bidangusaha = a.name;
bid.fk_mitra = a.fk_mitra;
bid.id = Convert.ToInt32(a.ID);
bidList1.Add(bid);
Session.Remove("tBidangUsahaList");
Session["tBidangUsahaList"] = bidList1;
}
// ambil m_pekerjaan done
var workDown = m_pekerjaan.selectWDFK(eID);
List <Object.WorkDone2> workDownList = new List <Object.WorkDone2>();
foreach (var a in workDown)
{
Object.WorkDone2 Wdone = new Object.WorkDone2();
Wdone.fk_mitra = Convert.ToInt32(a.fk_mitra);
Wdone.id = Convert.ToInt32(a.id);
Wdone.namapaket = a.namapaket;
Wdone.nilai = a.nilai;
Wdone.tanggalpelaksanaan = a.tanggalpelaksanaan;
Wdone.tanggalserah = a.tanggalserah;
Wdone.tipe = a.tipe;
Wdone.lokasi = a.lokasi;
workDownList.Add(Wdone);
Session.Remove("tWorkDoneList");
Session["tWorkDoneList"] = workDownList;
}
//ambil m_pekerjaan progress
var workProgres = m_pekerjaan.selectWPFK(eID);
List <Object.WorkProgress> workProgressList = new List <Object.WorkProgress>();
foreach (var a in workProgres)
{
Object.WorkProgress WP = new Object.WorkProgress();
WP.fk_mitra = Convert.ToInt32(a.fk_mitra);
WP.id = Convert.ToInt32(a.id);
WP.namapaket = a.namapaket;
WP.nilai = a.nilai;
WP.tanggalpelaksanaan = a.tanggalpelaksanaan;
WP.tanggalserah = a.tanggalserah;
WP.tipe = a.tipe;
WP.lokasi = a.lokasi;
workProgressList.Add(WP);
Session.Remove("tWorkProgressList");
Session["tWorkProgressList"] = workProgressList;
}
//ambil m_PIC
var PIC = m_pic.selectPICFK(eID);
List <Object.Pic> picList = new List <Object.Pic>();
foreach (var a in PIC)
{
Object.Pic pic = new Object.Pic();
pic.fk_mitra = Convert.ToInt32(a.fk_mitra);
pic.id = Convert.ToInt32(a.id);
pic.name = a.name;
pic.jabatan = a.description;
pic.noTelepon = a.noTelepon;
pic.email = a.email;
picList.Add(pic);
Session.Remove("tPicList");
Session["tPicList"] = picList;
}
//ambil m_PemegangSaham
var Saham = m_pemegangsaham.selectSahamFK(eID);
List <Object.PemegangSaham> SahamList = new List <Object.PemegangSaham>();
foreach (var a in Saham)
{
Object.PemegangSaham PS = new Object.PemegangSaham();
PS.fk_mitra = Convert.ToInt32(a.fk_mitra);
PS.id = Convert.ToInt32(a.id);
PS.name = a.name;
PS.jumlah = a.jumlah;
PS.persentase = a.persentase;
PS.total = a.total;
SahamList.Add(PS);
Session.Remove("tPemegangSahamList");
Session["tPemegangSahamList"] = SahamList;
}
//ambil BOD
var BOD = m_bod.selectBODFK(eID);
List <Object.BoardOfDirector> BODList = new List <Object.BoardOfDirector>();
foreach (var a in BOD)
{
Object.BoardOfDirector bod = new Object.BoardOfDirector();
bod.fk_mitra = Convert.ToInt32(a.fk_mitra);
bod.id = a.ID;
bod.name = a.name;
bod.jabatan = a.jabatan;
bod.tglLahir = a.tglLahir;
BODList.Add(bod);
Session.Remove("tBodList");
Session["tBodList"] = BODList;
}
//ambil checklist
Models.PenjaminanViewDatasetTableAdapters.BuatListTableAdapter ta = new Models.PenjaminanViewDatasetTableAdapters.BuatListTableAdapter();
List <Object.Checklist> checkList = new List <Object.Checklist>();
foreach (PenjaminanViewDataset.BuatListRow dr1 in ta.GetDataByfkMitra(id))
{
Object.Checklist check = new Object.Checklist();
check.id = dr1.ID;
check.name = dr1.name;
check.kategoriname = dr1.KategoryName;
check.FileName = dr1.FileName;
check.fk_mitra = id;
checkList.Add(check);
Session.Remove("documentDt");
Session["documentDt"] = checkList;
}
}
else
{
//ambil data mitra sesuai id
PenjaminanDataset.m_mitraRow dr = m_mitra.selectMitraByID(id);
List <Object.m_mitra> mitraLIst = new List <Object.m_mitra>();
Object.m_mitra mitra = new Object.m_mitra();
txtCalonMitra.Value = dr.name;
mitra.name = dr.name;
txtLatarBelakang.Value = dr.latarbelakang;
mitra.name = dr.latarbelakang;
mitra.status = dr.status;
if (mitra.status == "E")
{
txtStatusE.Checked = true;
}
else
{
txtStatusB.Checked = true;
}
Session.Remove("tMitra");
Session["tMitra"] = mitraLIst;
//session buat checklist
Models.PenjaminanViewDatasetTableAdapters.BuatListTableAdapter ta = new Models.PenjaminanViewDatasetTableAdapters.BuatListTableAdapter();
List <Object.Checklist> checkList = new List <Object.Checklist>();
foreach (PenjaminanViewDataset.BuatListRow dr1 in ta.GetDataByfkMitra(id))
{
Object.Checklist check = new Object.Checklist();
check.id = dr1.ID;
check.name = dr1.name;
check.kategoriname = dr1.KategoryName;
check.FileName = dr1.FileName;
checkList.Add(check);
check.fk_mitra = id;
}
Session.Remove("documentDt");
Session["documentDt"] = checkList;
}
}
