private void Fill()
{
Act.ProjectList(project);
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?tb=ISC064_MARKETINGJUAL..REF_JENISPROPERTI_LOG&Pk=" + NoJenis + "'";
btndel.Attributes["onclick"] = "location.href='JenisPropertiDel.aspx?NoJenis=" + NoJenis + "'";
string strSql = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_JENISPROPERTI WHERE SN = '" + NoJenis + "'";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString()))
{
Response.Redirect("/CustomError/SecLevel.html");
}
else
{
nojenis.Text = rs.Rows[0]["SN"].ToString();
jenis.Text = rs.Rows[0]["JenisProperti"].ToString();
namajenis.Text = rs.Rows[0]["Nama"].ToString();
Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString());
}
}
private void Fill()
{
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=" + Mi.DbPrefix + "FINANCEAR..REF_ACC_LOG&Pk=" + Acc + "'";
btndel.Attributes["onclick"] = "location.href='AccDel.aspx?Acc=" + Acc + "'";
string[] x = Cf.SplitByString(Acc, ";");
DataTable rs = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "FINANCEAR..REF_ACC WHERE Acc = '" + x[0] + "' AND SubID='" + x[1] + "'");
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString()))
{
Response.Redirect("/CustomError/SecLevel.html");
}
else
{
acc.Text = rs.Rows[0]["Acc"].ToString();
rekening.Text = rs.Rows[0]["Rekening"].ToString();
subid.Text = rs.Rows[0]["SubID"].ToString();
bank.Text = rs.Rows[0]["Bank"].ToString();
cabang1.Text = rs.Rows[0]["Cabang"].ToString();
atasnama.Text = rs.Rows[0]["AtasNama"].ToString();
saldoawal.Text = Cf.Num(rs.Rows[0]["SaldoAwal"]);
Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString());
}
}
private void Fill()
{
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?tb=ISC064_MARKETINGJUAL..REF_AGENT_LEVEL_LOG&Pk=" + NoLevel + "'";
btndel.Attributes["onclick"] = "location.href='LevelSalesDel.aspx?NoLevel=" + NoLevel + "'";
string strSql = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_LEVEL WHERE LevelID = '" + NoLevel + "'";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString()))
{
Response.Redirect("/CustomError/SecLevel.html");
}
else
{
nolevel.Text = rs.Rows[0]["LevelID"].ToString();
nama.Text = rs.Rows[0]["Nama"].ToString();
Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString());
string Tipe = Db.SingleString("SELECT Tipe FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE WHERE ID = '" + rs.Rows[0]["Tipe"].ToString() + "'");
tipe.Items.Add(new ListItem("Sekarang : " + Tipe, rs.Rows[0]["Tipe"].ToString()));
string Parent = Db.SingleString("SELECT Nama FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_LEVEL WHERE LevelID = '" + rs.Rows[0]["ParentID"].ToString() + "'");
Cf.SelectedValue(parent, Parent);
}
//string Tipe = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE WHERE ID = '" + rs.Rows[0]["Tipe"].ToString() + "'";
//DataTable rs2 = Db.Rs(Tipe);
//Cf.SelectedValue(tipe, rs2.Rows[0]["Tipe"].ToString());
//Cf.SelectedValue(parent, rs.Rows[0]["Nama"].ToString());
}
private void Fill()
{
Act.ProjectList(project);
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?tb=ISC064_MARKETINGJUAL..REF_JENIS_LOG&Pk=" + NoTipe + "'";
btndel.Attributes["onclick"] = "location.href='TipeSalesDel.aspx?NoTipe=" + NoTipe + "'";
string strSql = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE WHERE ID = '" + NoTipe + "'";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString()))
{
Response.Redirect("/CustomError/SecLevel.html");
}
else
{
notipe.Text = rs.Rows[0]["ID"].ToString();
tipe.Text = rs.Rows[0]["Tipe"].ToString();
Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString());
}
}
private void FillHeader()
{
Js.NumberFormat(barunominal);
Act.ProjectList(project);
UnitList(lokasi);
diskon.Attributes["onfocus"] = "tempnum=CalcFocus(this);tempdisc=this.value;";
diskon.Attributes["onblur"] = "if(this.value!=tempdisc){"
+ "recaldisc(document.getElementById('diskon'));"
+ "}";
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=" + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA_LOG&Pk=" + Nomor.PadLeft(3, '0') + "'";
btndel.Attributes["onclick"] = "location.href='SkemaDel.aspx?Nomor=" + Nomor + "'";
DataTable rsHeader = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA WHERE Nomor = " + Nomor);
if (rsHeader.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else if (!Act.AksesProject(rsHeader.Rows[0]["Project"].ToString()))
{
Response.Redirect("/CustomError/SecLevel.html");
}
else
{
nama.Text = rsHeader.Rows[0]["Nama"].ToString();
diskon.Text = rsHeader.Rows[0]["Diskon"].ToString();
diskonket.Text = rsHeader.Rows[0]["DiskonKet"].ToString();
bunga2.Text = rsHeader.Rows[0]["Bunga"].ToString();
bungaket.Text = rsHeader.Rows[0]["BungaKet"].ToString();
jenis.SelectedValue = rsHeader.Rows[0]["Jenis"].ToString();
Cf.SelectedValue(project, rsHeader.Rows[0]["Project"].ToString());
Cf.SelectedValue(lokasi, rsHeader.Rows[0]["TipeUnit"].ToString());
if (rsHeader.Rows[0]["Status"].ToString() == "A")
{
aktif.Checked = true;
inaktif.Checked = false;
}
else
{
aktif.Checked = false;
inaktif.Checked = true;
}
round.Checked = (bool)rsHeader.Rows[0]["RThousand"];
}
}
private void Fill()
{
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=REF_EMAIL_LOG&Pk=" + ID + "'";
btndel.Attributes["onclick"] = "location.href='AlamatEmailDel.aspx?ID=" + ID + "'";
string[] x = Cf.SplitByString(ID, ";");
DataTable rs = Db.Rs("SELECT * FROM REF_EMAIL WHERE ID = '" + x[0] + "'");
if (rs.Rows.Count == 0)
Response.Redirect("/CustomError/Deleted.html");
else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString()))
Response.Redirect("/CustomError/SecLevel.html");
else
{
id.Text = rs.Rows[0]["ID"].ToString();
email.Text = rs.Rows[0]["Email"].ToString();
Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString());
}
}
private void Fill()
{
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?tb=ISC064_MARKETINGJUAL..REF_FOLLOWUP_LOG&Pk=" + No + "'";
btndel.Attributes["onclick"] = "location.href='FollowUpDel.aspx?No=" + No + "'";
string strSql = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_FOLLOWUP WHERE No = '" + No + "'";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
nolokasi.Text = rs.Rows[0]["No"].ToString();
lokasi.Text = rs.Rows[0]["NamaGrouping"].ToString();
Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString());
}
}
private void Fill()
{
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=MS_CUSTOMER_LOG&Pk=" + NoCustomer.PadLeft(5, '0') + "'";
btndel.Attributes["onclick"] = "location.href='CustomerDel.aspx?NoCustomer=" + NoCustomer + "'";
string strSql = "SELECT * FROM MS_CUSTOMER WHERE NoCustomer = " + NoCustomer;
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
nocustomer.Text = rs.Rows[0]["NoCustomer"].ToString().PadLeft(5, '0');
if ((string)rs.Rows[0]["TipeCs"] == "PERORANGAN")
{
perorangan.Checked = true;
}
if ((string)rs.Rows[0]["TipeCs"] == "BADAN HUKUM")
{
badanhukum.Checked = true;
}
if (Convert.ToSByte(rs.Rows[0]["Refferator"]) == 1)
{
reff.Checked = true;
DataTable a = Db.Rs("SELECT * FROM MS_KONTRAK WHERE NoRefferatorAgent='" + rs.Rows[0]["NoCustomer"].ToString() + "' or NoRefferatorCustomer='" + rs.Rows[0]["NoCustomer"].ToString() + "' and Status='A'");
if (a.Rows.Count == 0)
{
reff.Enabled = true;
}
else
{
reff.Enabled = false;
}
}
else
{
reff.Checked = false;
}
nama.Text = rs.Rows[0]["Nama"].ToString();
nama2.Text = rs.Rows[0]["Nama2"].ToString();
salutation.Text = rs.Rows[0]["Salutation"].ToString();
namabisnis.Text = rs.Rows[0]["NamaBisnis"].ToString();
jenisbisnis.Text = rs.Rows[0]["JenisBisnis"].ToString();
merekbisnis.Text = rs.Rows[0]["MerekBisnis"].ToString();
namanpwp.Text = rs.Rows[0]["NamaNPWP"].ToString();
npwp.Text = rs.Rows[0]["NPWP"].ToString();
pekerjaan.Text = rs.Rows[0]["Pekerjaan"].ToString();
npwp1.Text = rs.Rows[0]["NPWPAlamat1"].ToString();
npwp2.Text = rs.Rows[0]["NPWPAlamat2"].ToString();
npwp3.Text = rs.Rows[0]["NPWPAlamat3"].ToString();
npwp4.Text = rs.Rows[0]["NPWPAlamat4"].ToString();
npwp5.Text = rs.Rows[0]["NPWPAlamat5"].ToString();
if ((string)rs.Rows[0]["Status"] == "A")
{
aktif.Checked = true;
}
else
{
inaktif.Checked = true;
}
notelp.Text = rs.Rows[0]["NoTelp"].ToString();
nohp.Text = rs.Rows[0]["NoHp"].ToString().Length > 2 ? rs.Rows[0]["NoHp"].ToString().Substring(0, 3) != "+62" ? rs.Rows[0]["NoHp"].ToString().Substring(1) : rs.Rows[0]["NoHp"].ToString().Substring(3) : "";
nohp2.Text = rs.Rows[0]["NoHP2"].ToString();
nokantor.Text = rs.Rows[0]["NoKantor"].ToString();
nofax.Text = rs.Rows[0]["NoFax"].ToString();
email.Text = rs.Rows[0]["Email"].ToString();
noktp.Text = rs.Rows[0]["NoKTP"].ToString();
ktp1.Text = rs.Rows[0]["KTP1"].ToString();
ktp2.Text = rs.Rows[0]["KTP2"].ToString();
ktp3.Text = rs.Rows[0]["KTP3"].ToString();
ktp4.Text = rs.Rows[0]["KTP4"].ToString();
ktp5.Text = rs.Rows[0]["KTP5"].ToString();
kodepos1.Text = rs.Rows[0]["Kodepos"].ToString();
alamat1.Text = rs.Rows[0]["Alamat1"].ToString();
alamat2.Text = rs.Rows[0]["Alamat2"].ToString();
alamat3.Text = rs.Rows[0]["Alamat3"].ToString();
alamat4.Text = rs.Rows[0]["Alamat4"].ToString();
alamat5.Text = rs.Rows[0]["Alamat5"].ToString();
kantor1.Text = rs.Rows[0]["Kantor1"].ToString();
kantor2.Text = rs.Rows[0]["Kantor2"].ToString();
kantor3.Text = rs.Rows[0]["Kantor3"].ToString();
kantor4.Text = rs.Rows[0]["Kantor4"].ToString();
kantor5.Text = rs.Rows[0]["Kantor5"].ToString();
nmorghub.Text = rs.Rows[0]["NamaKerabat"].ToString();
hubungan.SelectedValue = rs.Rows[0]["Hubungan"].ToString();
hphub.Text = rs.Rows[0]["NoHPKerabat"].ToString();
emailhub.Text = rs.Rows[0]["EmailKerabat"].ToString();
try
{
agama.SelectedValue = rs.Rows[0]["Agama"].ToString();
}
catch
{
agama.SelectedIndex = agama.Items.Count - 1;
}
tgllahir.Text = Cf.Day(rs.Rows[0]["TglLahir"]);
tglktp.Text = Cf.Day(rs.Rows[0]["TglKTP"]);
if (Convert.ToBoolean(rs.Rows[0]["KTPSeumurHidup"]) == true)
{
sedup.Checked = true;
tglktp.Text = "";
}
unitlama.Text = rs.Rows[0]["UnitLama"].ToString();
luaslama.Text = Cf.Num(rs.Rows[0]["LuasLama"]);
tokolama.Text = rs.Rows[0]["TokoLama"].ToString();
zoninglama.Text = rs.Rows[0]["ZoningLama"].ToString();
gedunglama.Text = rs.Rows[0]["GedungLama"].ToString();
teleponlama.Text = rs.Rows[0]["TeleponLama"].ToString();
aktelama.Text = rs.Rows[0]["AkteLama"].ToString();
tgltransaksi.Text = Cf.Day(rs.Rows[0]["TglTransaksi"]);
tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]);
tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]);
sumberdata.Items.Add(new ListItem(rs.Rows[0]["SumberData"].ToString()));
sumberdata.SelectedValue = rs.Rows[0]["SumberData"].ToString();
Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString());
int c1 = Db.SingleInteger("SELECT COUNT(*) FROM MS_KONTRAK WHERE NoCustomer = " + NoCustomer);
if (c1 > 0)
{
sifat.Text = "Sudah Beli";
}
else
{
sifat.Text = "Belum Beli";
}
tempatlahir.Text = rs.Rows[0]["TempatLahir"].ToString();
marital.SelectedValue = rs.Rows[0]["Marital"].ToString();
switch (rs.Rows[0]["Kewarganegaraan"].ToString())
{
case "WNI":
wni.Checked = true;
break;
case "WNA":
wna.Checked = true;
break;
case "KORPORASI INDONESIA":
kori.Checked = true;
break;
case "KORPORASI ASING":
kora.Checked = true;
break;
}
penanggungjawab.Text = rs.Rows[0]["PenanggungjawabKorp"].ToString();
jabatan.Text = rs.Rows[0]["JabatanKorp"].ToString();
nosk.Text = rs.Rows[0]["NoSKKorp"].ToString();
bentuk.Text = rs.Rows[0]["BentukKorp"].ToString();
if (kori.Checked || kora.Checked)
{
korp1.Visible = korp2.Visible = korp3.Visible = korp4.Visible = true;
}
else
{
korp1.Visible = korp2.Visible = korp3.Visible = korp4.Visible = false;
}
kori.Visible = false;
kora.Visible = false;
wni.Visible = true;
wni.Checked = true;
wna.Visible = true;
korp1.Visible = korp2.Visible = korp3.Visible = korp4.Visible = false;
}
}
