public static void Delete(int fkMitra)
{
PenjaminanDatasetTableAdapters.m_checklistTableAdapter taX = new PenjaminanDatasetTableAdapters.m_checklistTableAdapter();
PenjaminanDataset.m_checklistDataTable dt = taX.GetDataBy2(Convert.ToDecimal(fkMitra));
try
{
taX.softDelete("1", fkMitra);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
int tMitraID = 0;
//ini untuk nyimpen session nya si mitra ya
List <Object.m_mitra> mitraList = new List <Object.m_mitra>();
Object.m_mitra mitra = new Object.m_mitra();
if (Session["tMitra"] != null)
{
mitraList.AddRange((List <Object.m_mitra>)Session["tMitra"]);
}
//end
string status = "";
if (txtCalonMitra.Value == "")
{
throw new Exception("Field Calon Mitra is Mandatory");
}
if ((!txtStatusB.Checked && !txtStatusE.Checked) || (txtStatusB.Checked && txtStatusE.Checked))
{
throw new Exception("Field Status Mitra is Mandatory");
}
else
{
status = txtStatusB.Checked ? "B" : "L";
}
if (txtLatarBelakang.Value == "")
{
throw new Exception("Field latar belakang is Mandatory");
}
using (TransactionScope tr = new TransactionScope())
{
try
{
//insert and update mitra
if (eType == "add")
{
tMitraID = m_mitra.insertData(txtCalonMitra.Value, txtLatarBelakang.Value, status);
}
else
{
m_mitra.Update(eID, txtCalonMitra.Value, txtLatarBelakang.Value, status);
tMitraID = eID;
}
//insert and update bidangusaha
t_bidangusaha.insertData((List <Object.t_bidangusaha>)Session["tBidangUsahaList"], tMitraID);
m_pekerjaan.insertData((List <Object.WorkDone2>)Session["tWorkDoneList"], (List <Object.WorkProgress>)Session["tWorkProgressList"], tMitraID);
m_pic.insertData((List <Object.Pic>)Session["tPicList"], tMitraID);
m_pemegangsaham.insertData((List <Object.PemegangSaham>)Session["tPemegangSahamList"], tMitraID);
m_bod.insertData((List <Object.BoardOfDirector>)Session["tBodList"], tMitraID);
//<<-- START -->>
//insert
if (eType == "add")
{
Models.PenjaminanDatasetTableAdapters.m_checklistTableAdapter ta = new Models.PenjaminanDatasetTableAdapters.m_checklistTableAdapter();
fuSample.DataBind();
int c = 0;
foreach (var data in ((List <Object.Checklist>)Session["documentDt"]))
{
try
{
byte[] dataType = new byte[0];
int Size = 0;
var kukuk = fuSample.FileName;
string FileName = "";
var kukuruyuk = fuSample.PostedFiles[c].FileName;
if (fuSample.HasFile)
{
HttpPostedFile file = fuSample.PostedFile;
BinaryReader br = new BinaryReader(fuSample.PostedFiles[c].InputStream);
dataType = br.ReadBytes(file.ContentLength);
Size = fuSample.PostedFiles[c].ContentLength;
FileName = file.FileName;
ta.InsertQuery(tMitraID, data.id, kukuruyuk, data.kategoriname, 1, DateTime.Now, 1, DateTime.Now, "0", Size, dataType);
}
else
{
ta.InsertQuery(tMitraID, c + 1, kukuruyuk, data.kategoriname, 1, DateTime.Now, 1, DateTime.Now, "0", Size, dataType);
}
c++;
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
}
else //-->> buat update ceklist
{
Models.PenjaminanDatasetTableAdapters.m_checklistTableAdapter ta = new Models.PenjaminanDatasetTableAdapters.m_checklistTableAdapter();
fuSample.DataBind();
int c = 0;
foreach (var data in ((List <Object.Checklist>)Session["documentDt"]))
{
try
{
byte[] dataType = new byte[0];
int Size = 0;
var kukuk = fuSample.PostedFiles[c].FileName;
if (kukuk != "")
{
HttpPostedFile file = fuSample.PostedFiles[c];
BinaryReader br = new BinaryReader(fuSample.PostedFiles[c].InputStream);
dataType = br.ReadBytes(file.ContentLength);
Size = fuSample.PostedFiles[c].ContentLength;
int newID = data.id;
PenjaminanDataset.m_checklistDataTable dt = ta.GetDataByIdForEdit(newID);
if (dt != null)
{
ta.UpdateQuery(kukuk, 2, DateTime.Now, Size, dataType, data.id);
}
else
{
ta.InsertQuery(tMitraID, data.id, kukuk, data.kategoriname, 1, DateTime.Now, 1, DateTime.Now, "0", Size, dataType);
}
}
c++;
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
}
//<<-- END LAH -->>
tr.Complete();
tr.Dispose();
Session.Remove("tBidangUsahaList");
Session.Remove("tWorkDoneList");
Session.Remove("tWorkProgressList");
Session.Remove("tPicList");
Session.Remove("tPemegangSahamList");
Session.Remove("tBodList");
}
catch (Exception ex)
{
//Rollback
tr.Dispose();
throw ex;
}
}
Session.Remove("tMitra");
Session["tMitra"] = mitraList;
Response.Redirect("/Penjaminan/ViewMitra.aspx");
}
