protected void btnSubmit_Click(object sender, EventArgs e)
{
int tFkMitra = 0;
tFkMitra = eID;
long nilaiAkhir = long.Parse(Regex.Replace(txtNilai.Value, "[^0-9]+", string.Empty));
List <Object.WorkProgress> wpList = new List <Object.WorkProgress>();
Object.WorkProgress wp = new Object.WorkProgress();
if (Session["tWorkProgressList"] != null)
{
wpList.AddRange((List <Object.WorkProgress>)Session["tWorkProgressList"]);
}
wp.tipe = "P";
wp.namapaket = txtName.Value;
wp.lokasi = txtLokasi.Value;
wp.tanggalpelaksanaan = DateTime.Parse(txtTanggalPelaksanaan.Value);
wp.nilai = nilaiAkhir;
wp.tanggalserah = DateTime.Parse(txtTanggalSerah.Value);
if (eType == "add")
{
if (!wpList.Exists(x => x.tipe == wp.tipe && x.namapaket == wp.namapaket && x.lokasi == wp.lokasi))
{
wpList.Add(wp);
}
}
else
{
List <Object.WorkProgress> wdList = (List <Object.WorkProgress>)Session["tWorkProgressList"];
Object.WorkProgress wd = wdList.Find(y => y.id == eID);
wd.id = int.Parse(txtId.Value);
wd.namapaket = txtName.Value;
wd.lokasi = txtLokasi.Value;
wd.tanggalpelaksanaan = Convert.ToDateTime(txtTanggalPelaksanaan.Value);
wd.nilai = nilaiAkhir;
wd.tanggalserah = Convert.ToDateTime(txtTanggalSerah.Value);
tFkMitra = wd.fk_mitra;
}
Session.Remove("tWorkProgressList");
Session["tWorkProgressList"] = wpList;
if (tFkMitra != 0)
{
var eMaster = Request.QueryString["eTypeMaster"];
eMaster = "edit";
eID = tFkMitra;
Response.Redirect("/Penjaminan/EntryMitra.aspx?eID=" + tFkMitra + "&eType=" + eMaster);
}
else
{
Response.Redirect("/Penjaminan/EntryMitra.aspx?eType=" + eTypeMaster);
}
}
protected void fillForm(int id)
{
List <Object.WorkProgress> wpList = (List <Object.WorkProgress>)Session["tWorkProgressList"];
if (wpList.Exists(x => x.id == id))
{
Object.WorkProgress wp = wpList.Find(x => x.id == id);
txtId.Value = wp.id.ToString();
txtName.Value = wp.namapaket;
txtLokasi.Value = wp.lokasi;
txtTanggalPelaksanaan.Value = wp.tanggalpelaksanaan.ToString("yyyy-MM-dd");
txtNilai.Value = (Convert.ToInt64(wp.nilai)).ToString();
txtTanggalSerah.Value = wp.tanggalserah.ToString("yyyy-MM-dd");
}
}
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;
}
}