private void Fill()
{
string strSql = "SELECT * FROM MS_UNIT WHERE NoStock = '" + NoStock + "'";
DataTable rs = Db.Rs(strSql);
priority.Text = NoPriority;
nomorunit.Text = rs.Rows[0]["NoUnit"].ToString();
namacust.Text = Db.SingleString("SELECT Nama FROM MS_NUP INNER JOIN MS_CUSTOMER ON MS_NUP.NoCustomer=MS_CUSTOMER.NoCustomer WHERE NoNUP ='" + NoPriority + "'");
tipe.Text = rs.Rows[0]["Tipe"].ToString();
luas.Text = Cf.Num(rs.Rows[0]["LuasSG"]);
harga.Text = Cf.NumBulat(rs.Rows[0]["Pricelist"]);
unitpilih.Text = rs.Rows[0]["NoUnit"].ToString();
}
protected void fill()
{
//var d = db.SmsFormats.SingleOrDefault(p => p.Project == dept.SelectedValue && p.Tipe == Tipe);
//if (d != null)
//{
// waktu.Text = Cf.NumBulat(d.NilaiWaktu);
// satuan.SelectedValue = d.SatuanWaktu;
// format.Text = d.Format;
// inaktif.SelectedIndex = d.Inaktif ? 1 : 0;
//}
DataTable rsHeader = Db.Rs("SELECT * FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='" + Tipe + "'");
if (rsHeader.Rows.Count == 0)
{
tipe.Text = Tipe;
waktu.Text = "";
satuan.SelectedIndex = 0;
format.Text = "";
inaktif.SelectedIndex = 0;
}
else
{
tipe.Text = rsHeader.Rows[0]["Tipe"].ToString();
waktu.Text = Cf.NumBulat(rsHeader.Rows[0]["NilaiWaktu"]);
satuan.SelectedValue = (rsHeader.Rows[0]["SatuanWaktu"].ToString());
format.Text = rsHeader.Rows[0]["Format"].ToString();
inaktif.SelectedIndex = Convert.ToBoolean(rsHeader.Rows[0]["Inaktif"]) ? 1 : 0;
project.SelectedValue = (rsHeader.Rows[0]["Project"].ToString());
//decimal waktu2 = Db.SingleDecimal("SELECT ISNULL(NilaiWaktu, '0') FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='"+Tipe+ "'");
//string satuan2 = Db.SingleString("SELECT ISNULL(SatuanWaktu, '0') FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='" + Tipe + "'");
//string format2 = Db.SingleString("SELECT ISNULL(Format, '0') FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='" + Tipe + "'");
//string inaktif2 = Db.SingleString("SELECT ISNULL(Inaktif, '0') FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='" + Tipe + "'");
//string project2 = Db.SingleString("SELECT ISNULL(Project, '0') FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='" + Tipe + "'");
//waktu.Text = Convert.ToString(waktu2);
//satuan.Text = satuan2;
//format.Text = format2;
//inaktif.SelectedIndex = Convert.ToBoolean(inaktif2) ? 1:0 ;
//project.Text = project2;
}
if (Tipe != "UlangTahun")
{
divwaktu.Visible = true;
}
}
private void Fill()
{
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=MS_RESERVASI_LOG&Pk=" + NoReservasi.ToString().PadLeft(5, '0') + "'";
btndel.Attributes["onclick"] = "location.href='ReservasiDel.aspx?NoReservasi=" + NoReservasi + "'";
DataTable rs = Db.Rs("SELECT a.*, b.NoCustomer, b.Nama, DateDiff(Day,a.Tgl,a.TglExpire) as SisaWaktu "
+ " FROM MS_RESERVASI a"
+ " INNER JOIN MS_CUSTOMER b"
+ " ON a.NoCustomer = b.NoCustomer"
+ " WHERE a.NoReservasi = " + NoReservasi
);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
wl.Attributes["onclick"] = "location.href='UnitWL.aspx?NoStock=" + rs.Rows[0]["NoStock"] + "'";
if (rs.Rows[0]["Status"].ToString() == "A")
{
status.ForeColor = Color.Green;
status.Text = "Aktif";
}
else
{
status.ForeColor = Color.Red;
status.Text = "Expire";
}
noreservasi.Text = rs.Rows[0]["NoReservasi"].ToString();
noreservasifull.Text = rs.Rows[0]["NoReservasi2"].ToString();
int totalwl = Db.SingleInteger(
"SELECT COUNT(*) FROM MS_RESERVASI WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'");
nourut.Text = rs.Rows[0]["NoUrut"] + "/" + totalwl;
tgl.Text = Cf.Day(rs.Rows[0]["Tgl"]);
batas.Text = Cf.Date(rs.Rows[0]["TglExpire"]);
sisawaktu.Text = Cf.NumBulat(rs.Rows[0]["SisaWaktu"]);
noqueue.Text = rs.Rows[0]["NoQueue"].ToString();
nilai.Text = Cf.Num(rs.Rows[0]["Netto"]);
skema.SelectedValue = rs.Rows[0]["Skema"].ToString();
skema.Enabled = false;
agent.Items.Add(new ListItem(
"Tidak Berubah : " + rs.Rows[0]["NoAgent"].ToString().PadLeft(5, '0')
, rs.Rows[0]["NoAgent"].ToString()));
agent.SelectedValue = rs.Rows[0]["NoAgent"].ToString();
agent.Enabled = false;
supervisor.Text = rs.Rows[0]["Supervisor"].ToString();
manager.Text = rs.Rows[0]["Manager"].ToString();
//tanggal input, edit dan follow-up
tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]);
tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]);
printWL.InnerHtml = printWL.InnerHtml + " (" + rs.Rows[0]["PrintWL"] + ")";
printJadwalTagihan.InnerHtml = printJadwalTagihan.InnerHtml + " (" + rs.Rows[0]["PrintJadwalTagihan"] + ")";
printbform.InnerHtml = printbform.InnerHtml + " (" + rs.Rows[0]["printbform"] + ")";
string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'");
printWL.HRef = "PrintWL.aspx?NoReservasi=" + NoReservasi + "&project=" + Project;
printJadwalTagihan.HRef = "PrintJadwalTagihanReservasi.aspx?NoReservasi=" + NoReservasi + "&project=" + Project;
printbform.HRef = "PrintBForm.aspx?NoReservasi=" + NoReservasi + "&project=" + Project;
//req panahome
int countTTS = Db.SingleInteger("select Count(*) from " + Mi.DbPrefix + "FINANCEAR..MS_TTS where NoReservasi = '" + NoReservasi + "' and Project = '" + Project + "'");
if (countTTS != 0)
{
int NoTTS = Db.SingleInteger("select ISNULL(NoTTS, 0) from " + Mi.DbPrefix + "FINANCEAR..MS_TTS where NoReservasi = '" + NoReservasi + "' and Project = '" + Project + "'");
int PrintTTS = Db.SingleInteger("select ISNULL(PrintTTS, 0) from " + Mi.DbPrefix + "FINANCEAR..MS_TTS where NoReservasi = '" + NoReservasi + "' and Project = '" + Project + "'");
printtts.HRef = "PrintTTS.aspx?NoTTS=" + NoTTS + "&project=" + Project;
printtts.InnerHtml = printtts.InnerHtml + " (" + PrintTTS + ")";
}
else
{
printtts.Visible = true;
}
}
}
private void Fill()
{
string strSql = "SELECT *"
+ ",CASE CaraBayar"
+ " WHEN 'TN' THEN 'TUNAI'"
+ " WHEN 'KK' THEN 'KARTU KREDIT'"
+ " WHEN 'KD' THEN 'KARTU DEBIT'"
+ " WHEN 'TR' THEN 'TRANSFER BANK'"
+ " WHEN 'BG' THEN 'CEK GIRO'"
+ " WHEN 'UJ' THEN 'UANG JAMINAN'"
+ " WHEN 'DN' THEN 'DISKON'"
+ " END AS CaraBayar2"
+ " FROM " + Mi.DbPrefix + "FINANCEAR..MS_TTS WHERE NoTTS = " + nomor;
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count != 0)
{
namacs.Text = Cf.Str(rs.Rows[0]["Customer"]);
Customer.Text = Cf.Str(rs.Rows[0]["Customer"]);
noAcc.Text = Cf.Str(rs.Rows[0]["Acc"]);
//req nomor panahome (reset perbulan)
nobkm.Text = rs.Rows[0]["NoTTS2"].ToString();
tglbkm.Text = Cf.DayIndo(rs.Rows[0]["Tgltts"]);
nosp.Text = rs.Rows[0]["Ref"].ToString();
nilainup.Text = nominal.Text = Cf.Num(rs.Rows[0]["Total"]);
//int temp = Convert.ToInt16(Cf.Num(rs.Rows[0]["Total"]));
jumlahUnit.Text = rs.Rows[0]["Unit"].ToString();
terbilangnilainup.Text = Money.Str(Convert.ToDecimal(rs.Rows[0]["Total"])) + " RUPIAH";
if (rs.Rows[0]["Acc"].ToString() != "-")
{
bankacc.Text = Db.SingleString("select ISNULL(Bank, '') from REF_ACC where Acc = '" + rs.Rows[0]["Acc"].ToString() + "'") + " (" + rs.Rows[0]["CaraBayar2"].ToString() + ")";
}
else
{
bankacc.Text = "Cash";
}
tglttd.Text = Cf.DayIndo(rs.Rows[0]["TglTTS"]);
tglbankacc.Text = Cf.DayIndo(rs.Rows[0]["TglTTS"]);
decimal PpnNUP = Convert.ToDecimal(rs.Rows[0]["Total"]) / (decimal)1.1;
decimal DppNUP = Convert.ToDecimal(rs.Rows[0]["Total"]) - PpnNUP;
dppnup.Text = Cf.NumBulat(PpnNUP);
ppnnup.Text = Cf.NumBulat(DppNUP);
baya.Text = rs.Rows[0]["ket"].ToString();
//fill data customer
int CountNUP = Db.SingleInteger("select count(*) from " + Mi.DbPrefix + "MARKETINGJUAL..MS_NUP where NoNUP = '" + rs.Rows[0]["NoNUP"] + "'");
if (CountNUP != 0)
{
string strSqlNUP = "";
strSqlNUP = "SELECT "
+ " b.KTP1"
+ " ,b.KTP2"
+ " ,b.KTP3"
+ " ,b.KTP4"
+ " ,b.KTP5"
+ " ,b.Kodepos"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_NUP a INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer WHERE a.NoNUP = '" + rs.Rows[0]["NoNUP"] + "'";
DataTable rsNUP = Db.Rs(strSqlNUP);
for (int j = 0; j < rsNUP.Rows.Count; j++)
{
alamat1.Text = rsNUP.Rows[j]["KTP1"].ToString();
alamat2.Text = rsNUP.Rows[j]["KTP2"].ToString() + " " + rsNUP.Rows[j]["KTP3"].ToString();
alamat3.Text = rsNUP.Rows[j]["KTP4"].ToString() + " " + rsNUP.Rows[j]["KTP5"].ToString() + " " + rsNUP.Rows[j]["Kodepos"].ToString();
}
}
else
{
string strSqlKontrak = "SELECT "
+ " b.KTP1"
+ " ,b.KTP2"
+ " ,b.KTP3"
+ " ,b.KTP4"
+ " ,b.KTP5"
+ " ,b.Kodepos"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK a INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer WHERE a.NoKontrak = '" + rs.Rows[0]["Ref"] + "'";
DataTable rsKon = Db.Rs(strSqlKontrak);
for (int j = 0; j < rsKon.Rows.Count; j++)
{
alamat1.Text = rsKon.Rows[j]["KTP1"].ToString();
alamat2.Text = rsKon.Rows[j]["KTP2"].ToString() + " " + rsKon.Rows[j]["KTP3"].ToString();
alamat3.Text = rsKon.Rows[j]["KTP4"].ToString() + " " + rsKon.Rows[j]["KTP5"].ToString() + " " + rsKon.Rows[j]["Kodepos"].ToString();
}
}
//fill data unit
int CountUnit = Db.SingleInteger("select count(*) from " + Mi.DbPrefix + "MARKETINGJUAL..MS_UNIT where NoUnit = '" + rs.Rows[0]["Unit"] + "'");
if (CountUnit != 0)
{
string strSqlUnit = "";
strSqlUnit = "SELECT * "
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_UNIT WHERE NoUnit = '" + rs.Rows[0]["Unit"] + "'";
DataTable rsUnit = Db.Rs(strSqlUnit);
for (int k = 0; k < rsUnit.Rows.Count; k++)
{
nounit.Text = rsUnit.Rows[k]["Nomor"].ToString();
jalan.Text = rsUnit.Rows[k]["NamaJalan"].ToString();
cluster.Text = rsUnit.Rows[k]["Lokasi"].ToString();
}
}
else
{
hide1.Visible = false;
hide2.Visible = false;
hide3.Visible = false;
}
}
}
private void Fill()
{
string strSql = "SELECT * FROM MS_KONTRAK "
+ " WHERE NoKontrak = '" + nomor + "' and Project = '" + proj + "'"
;
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count > 0)
{
NoKontrak1.Text = rs.Rows[0]["NoKontrak"].ToString();
hargajual1.Text = Cf.NumBulat(rs.Rows[0]["Gross"]);
hargapengikat1.Text = Cf.NumBulat(rs.Rows[0]["NilaiKontrak"]);
ppn1.Text = Cf.NumBulat(rs.Rows[0]["NilaiPPN"]);
terbilang.Text = Money.Str(Convert.ToDecimal(rs.Rows[0]["NilaiKontrak"])) + " RUPIAH";
skema.Text = Db.SingleString("select ISNULL(Nama, '') from REF_SKEMA where Nomor = '" + rs.Rows[0]["Refskema"] + "'");
sales.Text = Db.SingleString("SELECT NAMA FROM MS_AGENT WHERE NoAgent = " + rs.Rows[0]["NoAgent"].ToString());
//vabca.Text = rs.Rows[0]["NoVA"].ToString();
string Nova = rs.Rows[0]["NoVA"].ToString();
string KodeProVA = Nova.Substring(0, 5);
string TahunBulanVA = Nova.Substring(5, 4);
string TipeVA = Nova.Substring(9, 3);
string NomorVA = Nova.Substring(12, 4);
vabca.Text = KodeProVA + "-" + TahunBulanVA + "-" + TipeVA + "-" + NomorVA;
tglsp.Text = Cf.Day(Convert.ToDateTime(rs.Rows[0]["TglKontrak"]));
DataTable rs1 = Db.Rs("SELECT * FROM MS_UNIT WHERE NoUnit='" + rs.Rows[0]["NoUnit"].ToString() + "'");
string Lokasi = "";
if (rs1.Rows.Count > 0)
{
string tipe1 = Db.SingleString("select jenis from ms_unit where nounit = '" + rs.Rows[0]["NoUnit"].ToString() + "'");
string tipe2 = Db.SingleString("select Nama from Ref_jenis where jenis = '" + tipe1 + "'");
tipeunit.Text = tipe2;
luassg.Text = Cf.Num(rs1.Rows[0]["LuasSG"]) + " M<sup>2</sup>";
luasnett.Text = Cf.Num(rs1.Rows[0]["LuasNett"]) + " M<sup>2</sup>";
lantai.Text = rs1.Rows[0]["Lantai"].ToString();
nounit.Text = rs1.Rows[0]["Nomor"].ToString();
}
tower.Text = "Paul Marc";// rs.Rows[0]["Lokasi"].ToString();
////fill data customer
int CountCus = Db.SingleInteger("select count(*) from MS_CUSTOMER where NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'");
if (CountCus != 0)
{
string strSqlCus = "";
strSqlCus = "SELECT * FROM MS_CUSTOMER WHERE NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'";
DataTable rsCus = Db.Rs(strSqlCus);
for (int j = 0; j < rsCus.Rows.Count; j++)
{
namacs.Text = cs2.Text = rsCus.Rows[j]["Nama"].ToString();
noktp.Text = rsCus.Rows[j]["NoKTP"].ToString();
nonpwp.Text = rsCus.Rows[j]["NPWP"].ToString();
Almt.Text = rsCus.Rows[j]["KTP1"].ToString();
Almt2.Text = rsCus.Rows[j]["KTP2"].ToString();
Almt3.Text = rsCus.Rows[j]["KTP3"].ToString();
Almt4.Text = rsCus.Rows[j]["KTP4"].ToString() + "," + rsCus.Rows[j]["KTP5"].ToString();
AlmtSrt.Text = rsCus.Rows[j]["Alamat1"].ToString();
AlmtSrt2.Text = rsCus.Rows[j]["Alamat2"].ToString();
AlmtSrt3.Text = rsCus.Rows[j]["Alamat3"].ToString();
AlmtSrt4.Text = rsCus.Rows[j]["Alamat4"].ToString() + " " + rsCus.Rows[j]["Alamat5"].ToString();
hp.Text = rsCus.Rows[j]["NoHP"].ToString();
hpkerabat.Text = rsCus.Rows[j]["NoHPKerabat"].ToString();
email.Text = rsCus.Rows[j]["Email"].ToString();
telp.Text = rsCus.Rows[j]["NoTelp"].ToString();
NoKantor1.Text = rsCus.Rows[j]["NoKantor"].ToString();
}
}
////fill data unit
//int CountUnit = Db.SingleInteger("select count(*) from MS_UNIT where NoStock = '" + rs.Rows[0]["NoStock"] + "'");
//if (CountUnit != 0)
//{
// string strSqlUnit = "";
// strSqlUnit = "SELECT * FROM MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'";
// DataTable rsUnit = Db.Rs(strSqlUnit);
// for (int k = 0; k < rsUnit.Rows.Count; k++)
// {
// jenisproperti.Text = rsUnit.Rows[k]["JenisProperti"].ToString();
// namajalan.Text = rsUnit.Rows[k]["NamaJalan"].ToString();
// nounit.Text = rsUnit.Rows[k]["Nomor"].ToString().PadLeft(2, '0');
// jenis.Text = rsUnit.Rows[k]["Jenis"].ToString();
// luasnett.Text = Cf.Num(rsUnit.Rows[k]["LuasNett"]);
// luassg.Text = Cf.Num(rsUnit.Rows[k]["LuasSG"]);
// lokasi.Text = rsUnit.Rows[k]["Lokasi"].ToString();
// }
//}
////gimmick
//int CountGimmick = Db.SingleInteger("select count(*) from MS_KONTRAK_GIMMICK where NoKontrak = '" + nomor + "'");
//if (CountGimmick != 0)
//{
// gimmicktr.Visible = true;
// FillTb();
//}
//else
//{
// gimmicktr.Visible = false;
//}
}
}
private void Fill()
{
string strSql = "SELECT * FROM MS_KONTRAK "
+ " WHERE NoKontrak = '" + nomor + "' and Project = '" + proj + "'"
;
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count > 0)
{
nokontrak.Text = rs.Rows[0]["NoKontrak"].ToString();
tglkontrak.Text = Cf.DayIndo(rs.Rows[0]["TglKontrak"]);
// namaproject.Text = rs.Rows[0]["NamaProject"].ToString();
namapers.Text = rs.Rows[0]["NamaPers"].ToString();
nilaikontrak.Text = Cf.NumBulat(rs.Rows[0]["NilaiKontrak"]);
skema.Text = Db.SingleString("select ISNULL(Nama, '') from REF_SKEMA where Nomor = '" + rs.Rows[0]["Refskema"] + "'");
//ag.Text = Db.SingleString("SELECT NAMA FROM MS_AGENT WHERE NoAgent = " + rs.Rows[0]["NoAgent"].ToString());
//fill data customer
int CountCus = Db.SingleInteger("select count(*) from MS_CUSTOMER where NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'");
if (CountCus != 0)
{
string strSqlCus = "";
strSqlCus = "SELECT * FROM MS_CUSTOMER WHERE NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'";
DataTable rsCus = Db.Rs(strSqlCus);
for (int j = 0; j < rsCus.Rows.Count; j++)
{
namacs.Text = namacs2.Text = rsCus.Rows[j]["Nama"].ToString();
noktp.Text = rsCus.Rows[j]["NoKTP"].ToString();
npwp.Text = rsCus.Rows[j]["NPWP"].ToString();
alamatktp1.Text = rsCus.Rows[j]["KTP1"].ToString() + " " + rsCus.Rows[j]["KTP2"].ToString() + " " + rsCus.Rows[j]["KTP3"].ToString();
alamatktp2.Text = rsCus.Rows[j]["KTP4"].ToString() + " " + rsCus.Rows[j]["KTP5"].ToString();
alamatsekarang1.Text = rsCus.Rows[j]["Alamat1"].ToString() + " " + rsCus.Rows[j]["Alamat2"].ToString() + " " + rsCus.Rows[j]["Alamat3"].ToString();
alamatsekarang2.Text = rsCus.Rows[j]["Alamat4"].ToString() + " " + rsCus.Rows[j]["Alamat5"].ToString();
hp1.Text = rsCus.Rows[j]["NoHP"].ToString();
hp2.Text = rsCus.Rows[j]["NoHP2"].ToString();
// email.Text = rsCus.Rows[j]["Email"].ToString();
}
}
//fill data unit
int CountUnit = Db.SingleInteger("select count(*) from MS_UNIT where NoStock = '" + rs.Rows[0]["NoStock"] + "'");
if (CountUnit != 0)
{
string strSqlUnit = "";
strSqlUnit = "SELECT * FROM MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'";
DataTable rsUnit = Db.Rs(strSqlUnit);
for (int k = 0; k < rsUnit.Rows.Count; k++)
{
// jenisproperti.Text = rsUnit.Rows[k]["JenisProperti"].ToString();
namajalan.Text = rsUnit.Rows[k]["NamaJalan"].ToString();
nounit.Text = rsUnit.Rows[k]["Nomor"].ToString().PadLeft(2, '0');
jenis.Text = rsUnit.Rows[k]["Jenis"].ToString();
luasnett.Text = Cf.Num(rsUnit.Rows[k]["LuasNett"]);
luassg.Text = Cf.Num(rsUnit.Rows[k]["LuasSG"]);
lokasi.Text = rsUnit.Rows[k]["Lokasi"].ToString();
}
}
//gimmick
int CountGimmick = Db.SingleInteger("select count(*) from MS_KONTRAK_GIMMICK where NoKontrak = '" + nomor + "'");
if (CountGimmick != 0)
{
// gimmicktr.Visible = true;
FillTb();
}
else
{
//gimmicktr.Visible = false;
}
}
}
private void Fill()
{
aKey.HRef = "javascript:openModal('KontrakEditKey.aspx?NoKontrak=" + NoKontrak + "','350','220')";
aStatus.HRef = "javascript:openModal('KontrakStatus.aspx?NoKontrak=" + NoKontrak + "','500','500')";
//printSuratLunas.HRef = "PrintSuratLunas.aspx?NoKontrak=" + NoKontrak;
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=MS_KONTRAK_LOG&Pk=" + NoKontrak + "'";
btndel.Attributes["onclick"] = "location.href='KontrakDel.aspx?NoKontrak=" + NoKontrak + "&NoStock=" + NoStock + "'";
refresh.Attributes["onclick"] = "if(confirm('"
+ "Apakah anda ingin mengambil ulang data unit ?\\n"
+ "Perhatian bahwa nilai GROSS dan DISKON bisa berubah."
+ "'))"
+ "{location.href='KontrakRefresh.aspx?NoKontrak=" + NoKontrak + "'}";
string strSql = "SELECT *"
+ " FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
nokontrak.Text = rs.Rows[0]["NoKontrak"].ToString();
nkm.Text = rs.Rows[0]["NoKontrakManual"].ToString();
if (Convert.ToInt16(rs.Rows[0]["FlagProsesBatal"]) == 1)
{
prosesbatal.Checked = true;
}
else
{
prosesbatal.Checked = false;
}
string stat = rs.Rows[0]["Status"].ToString();
if (stat == "A")
{
status.ForeColor = Color.RoyalBlue;
status.Text = "Aktif";
}
else if (stat == "B")
{
status.ForeColor = Color.Red;
status.Text = "Batal";
}
else if (stat == "E")
{
status.ForeColor = Color.Gray;
status.Text = "Proses Batal";
}
tglkontrak.Text = Cf.Day(rs.Rows[0]["TglKontrak"]);
targetst.Text = Cf.Day(rs.Rows[0]["TargetST"]);
nokused.SelectedValue = rs.Rows[0]["nokused"].ToString();
lokpen.SelectedValue = rs.Rows[0]["LokasiPenjualan"].ToString();
//tanggal input, edit dan follow-up
tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]);
tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]);
decimal Luas = Convert.ToDecimal(rs.Rows[0]["Luas"]);
luas.Text = Cf.Num(Luas);
string ket = "";
switch ((int)rs.Rows[0]["FlagGross"])
{
case 1:
ket = "Edit Kontrak";
break;
case 2:
ket = "Refresh Unit";
break;
case 3:
ket = "Pindah Unit";
break;
case 4:
ket = "Serah Terima";
break;
}
decimal t = 0;
decimal bungaNominal = Db.SingleDecimal("SELECT ISNULL(BungaNominal,0) FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'");//checkNull(rs.Rows[0]["BungaNominal"]);
gross.Text = Cf.Num(rs.Rows[0]["Gross"]);
//biayalainlain.Text = Cf.Num(rs.Rows[0]["HargaLainLain"]);
//biayagimmick.Text = Cf.Num(rs.Rows[0]["HargaGimmick"]);
diskon.Text = Cf.Num(Convert.ToDecimal(rs.Rows[0]["DiskonRupiah"]));
diskontambahan.Text = Cf.Num(Convert.ToDecimal(rs.Rows[0]["DiskonTambahan"]));
afterdisc.Text = Cf.Num(Convert.ToDecimal(rs.Rows[0]["Gross"]) - Convert.ToDecimal(rs.Rows[0]["DiskonRupiah"]) - Convert.ToDecimal(rs.Rows[0]["DiskonTambahan"]));
hargaSD.Text = Cf.Num(Convert.ToDecimal(rs.Rows[0]["Gross"]) + Convert.ToDecimal(rs.Rows[0]["HargaLainLain"]) + Convert.ToDecimal(rs.Rows[0]["HargaGimmick"]));
lblBunga.Text = Cf.Num(bungaNominal);
decimal nilaiKontrak = Convert.ToDecimal(rs.Rows[0]["NilaiKontrak"]) + Convert.ToDecimal(rs.Rows[0]["NilaiPPN"]);
nilai.Text = Cf.Num(rs.Rows[0]["NilaiKontrak"]);
hargatanah.Text = Cf.NumBulat(rs.Rows[0]["HargaTanah"]);
note.Text = rs.Rows[0]["Note"].ToString();
titipjual.SelectedValue = rs.Rows[0]["TitipJual"].ToString();
if (rs.Rows[0]["PaketInvestasi"].ToString() == "1")
{
paketinvest.Checked = true;
tglinv.Text = Cf.Day(rs.Rows[0]["TglPaketInvestasi"]);
}
lblDPP.Text = Cf.Num(Math.Round(Db.SingleDecimal("SELECT ISNULL(NilaiDPP,0) FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "' ")));
lblPPN.Text = ppn.Text = Cf.Num(Math.Round(Convert.ToDecimal(rs.Rows[0]["NilaiPPN"])));
if (Convert.ToDecimal(rs.Rows[0]["NilaiPPN"]) == 0)
{
DPP2.Text = Cf.Num(rs.Rows[0]["NilaiKontrak"]);
PPN2.Text = "0";
}
else
{
DPP2.Text = Cf.Num(Math.Round(Convert.ToDecimal(nilai.Text) / (decimal)1.1));
PPN2.Text = Cf.Num(Math.Round(Convert.ToDecimal(DPP2.Text) * (decimal)0.1));
}
//refresh info
DataTable rsunit = Db.Rs("SELECT NoUnit, Luas, PriceList "
+ " FROM MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'");
if (rsunit.Rows.Count != 0)
{
if (rsunit.Rows[0]["NoUnit"].ToString() != rs.Rows[0]["NoUnit"].ToString() ||
Convert.ToDecimal(rsunit.Rows[0]["Luas"]) != Convert.ToDecimal(rs.Rows[0]["Luas"]) ||
Convert.ToDecimal(rsunit.Rows[0]["PriceList"]) != Convert.ToDecimal(rs.Rows[0]["Gross"])
)
{
refreshinfo.Text = "DATA ADMINISTRASI BERBEDA";
}
else
{
refresh.Disabled = true;
}
}
//agent
agent.Items.Add(new ListItem(
"Tidak Berubah : " + rs.Rows[0]["NoAgent"].ToString().PadLeft(5, '0')
, rs.Rows[0]["NoAgent"].ToString()));
agent.SelectedValue = rs.Rows[0]["NoAgent"].ToString();
string TipeAgent = Db.SingleString("SELECT Tipe FROM MS_AGENT WHERE NoAgent = '" + rs.Rows[0]["NoAgent"] + "'");
if (TipeAgent == "INHOUSE")
{
reff.Visible = true;
}
else
{
reff.Visible = false;
}
//refferator
if (rs.Rows[0]["NoRefferatorAgent"].ToString() != "")
{
agentreff.Items.Add(new ListItem(
"Tidak Berubah : " + rs.Rows[0]["NoRefferatorAgent"].ToString().PadLeft(5, '0')
, rs.Rows[0]["NoRefferatorAgent"].ToString()));
agentreff.SelectedValue = rs.Rows[0]["NoRefferatorAgent"].ToString() + ";EMPLOYEE";
}
else
{
agentreff.Items.Add(new ListItem(
"Tidak Berubah : " + rs.Rows[0]["NoRefferatorCustomer"].ToString().PadLeft(5, '0')
, rs.Rows[0]["NoRefferatorCustomer"].ToString()));
agentreff.SelectedValue = rs.Rows[0]["NoRefferatorCustomer"].ToString() + ";BUYER";
}
skema.Text = rs.Rows[0]["Skema"].ToString();
batal.Text = rs.Rows[0]["AlasanBatal"].ToString();
if (batal.Text == "")
{
bataltr.Visible = false;
}
ppjb.Text = Cf.Day(rs.Rows[0]["TglPPJB"])
+ " "
+ "<u>" + rs.Rows[0]["NoPPJB"] + "</u>";
ppjbused.SelectedValue = rs.Rows[0]["PPJBu"].ToString();
if (rs.Rows[0]["NoPPJB"] == "")
{
ppjbm.ReadOnly = true;
jbm.Visible = false;
}
else
{
ppjbm.Text = rs.Rows[0]["NoPPJBm"].ToString();
}
ajb.Text = Cf.Day(rs.Rows[0]["TglAJB"])
+ " "
+ "<u>" + rs.Rows[0]["NoAJB"] + "</u>";
//serah terima
if ((string)rs.Rows[0]["ST"] == "T")
{
st.Text = "<b>Terlambat</b>";
}
else if ((string)rs.Rows[0]["ST"] == "D")
{
st.Text = Cf.Day(rs.Rows[0]["TglST"])
+ " "
+ "<u>" + rs.Rows[0]["NoST"] + "</u>";
}
printSP.InnerHtml = printSP.InnerHtml + " (" + rs.Rows[0]["PrintSP"] + ")";
printPPJB.InnerHtml = printPPJB.InnerHtml + " (" + rs.Rows[0]["PrintPPJB"] + ")";
printAJB.InnerHtml = printAJB.InnerHtml + " (" + rs.Rows[0]["PrintAJB"] + ")";
printBAST.InnerHtml = printBAST.InnerHtml + " (" + rs.Rows[0]["PrintBAST"] + ")";
printRKOM.InnerHtml = printRKOM.InnerHtml + " (" + rs.Rows[0]["PrintRKOM"] + ")";
printFPS.InnerHtml = printFPS.InnerHtml + " (" + rs.Rows[0]["PrintFPS"] + ")";
JenisPPN.SelectedValue = rs.Rows[0]["JenisPPN"].ToString();
if (Convert.ToBoolean(rs.Rows[0]["JenisKPR"]))
{
jeniskpr.Items[1].Selected = true;
}
else
{
jeniskpr.Items[0].Selected = true;
}
if (rs.Rows[0]["CaraBayar"].ToString() == "KPR")
{
carabayar2.Items[0].Selected = true;
}
else if (rs.Rows[0]["CaraBayar"].ToString() == "CASH BERTAHAP")
{
carabayar2.Items[1].Selected = true;
}
else if (rs.Rows[0]["CaraBayar"].ToString() == "CASH KERAS")
{
carabayar2.Items[2].Selected = true;
}
else if (rs.Rows[0]["CaraBayar"].ToString() == "")
{
carabayar2.ClearSelection();
}
nilaikpa.Text = Cf.Num(rs.Rows[0]["NilaiRealisasiKPR"]);
rekcair.Items.Add(new ListItem("Sekarang : " + rs.Rows[0]["RekeningCairKPR"], rs.Rows[0]["RekeningCairKPR"].ToString()));
rekcair.Items[rekcair.Items.Count - 1].Selected = true;
if (rs.Rows[0]["PPJB"].ToString() == "D")
{
tra.Visible = true;
trb.Visible = true;
}
else
{
tra.Visible = false;
trb.Visible = false;
}
//Faktur Pajak Standar
if (rs.Rows[0]["AJB"].ToString() == "D")
{
printFPS.Visible = true;
kdPajak.Enabled = true;
//noFPS.ReadOnly = true;
}
else
{
printFPS.Visible = false;
kdPajak.SelectedValue = "";
kdPajak.Enabled = false;
//noFPS.ReadOnly = true;
}
if (rs.Rows[0]["Status"].ToString() == "B")
{
trc.Visible = trd.Visible = tre.Visible = trf.Visible = trk.Visible = true;
printFBatal.Visible = true;
}
else
{
trc.Visible = trd.Visible = tre.Visible = trf.Visible = trk.Visible = false;
printFBatal.Visible = false;
}
//Fill No Faktur Pajak
string kp = Db.SingleString("SELECT NoFPS FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'");
if (kp == "")
{
kdPajak.SelectedValue = "";
noFPS.Text = "";
}
else
{
string kp2 = kp.Substring(0, 3);
if (kp2 == "010")
{
kdPajak.SelectedValue = "010";
noFPS.Text = Cf.Str(rs.Rows[0]["NoFPS"]).ToString().Substring(3, 16);
}
else
{
kdPajak.SelectedValue = "011";
noFPS.Text = Cf.Str(rs.Rows[0]["NoFPS"]).ToString().Substring(3, 16);
}
}
nilaiklaim.Text = Cf.Num(rs.Rows[0]["NilaiKlaim"]);
totallunas.Text = Cf.Num(rs.Rows[0]["TotalLunasBatal"]);
nilaipulang.Text = Cf.Num(rs.Rows[0]["NilaiPulang"]);
tglkembali.Text = Cf.Day(rs.Rows[0]["TglKembali"]);
reffcust.Text = rs.Rows[0]["reffcust"].ToString();
anreff.Text = rs.Rows[0]["anreff"].ToString();
bankreff.Text = rs.Rows[0]["bankreff"].ToString();
npwpreff.Text = rs.Rows[0]["npwpreff"].ToString();
norekreff.Text = rs.Rows[0]["norekreff"].ToString();
acc.Items.Add(new ListItem("Tidak berubah: " + rs.Rows[0]["AccBatal"], rs.Rows[0]["AccBatal"].ToString()));
acc.SelectedIndex = acc.Items.Count - 1;
if (Convert.ToBoolean(rs.Rows[0]["FOBO"]) || Convert.ToBoolean(rs.Rows[0]["FOBOBatal"]))
{
btndel.Attributes["disabled"] = "true";
}
focounter.Text = (Db.SingleInteger("SELECT ISNULL(COUNT(*),0) FROM MS_TAGIHAN WHERE NoKontrak = '" + NoKontrak + "' AND NamaTagihan LIKE 'FITTING OUT%'")).ToString();
decimal fitting = Db.SingleDecimal("SELECT ISNULL(SUM(NilaiTagihan), 0) FROM MS_TAGIHAN WHERE NoKontrak = '" + NoKontrak + "' AND NamaTagihan LIKE 'FITTING OUT%'");
fo.Text = Cf.Num(Math.Round(fitting));
//nilai ini berguna untuk mengecek nilai focounter dan fo
//apabila focounter dan fo berubah maka data berubah
foCheck = focounter.Text;
focounterCheck = fo.Text;
//status PPN
if ((bool)rs.Rows[0]["PPN"])
{
statusPPN.Text = "<b>(INCLUDE)</b>";
}
else if (!(bool)rs.Rows[0]["PPN"])
{
statusPPN.Text = "<b>(EXCLUDE)</b>";
}
/*Sumber Dana*/
ddlSumberDana.SelectedValue = rs.Rows[0]["SumberDana"].ToString();
if ((int)rs.Rows[0]["SumberDana"] == 3)
{
trLainnya.Visible = true;
}
else
{
trLainnya.Visible = false;
}
lainnya.Text = rs.Rows[0]["SumberDanaLainnya"].ToString();
ddlTujuan.SelectedValue = rs.Rows[0]["TujuanKontrak"].ToString();
if (rs.Rows[0]["TujuanKontrak"].ToString() == "3")
{
trTujuanLain.Visible = true;
}
else
{
trTujuanLain.Visible = false;
}
tujuanlain.Text = rs.Rows[0]["TujuanLainnya"].ToString();
noqueue.Text = rs.Rows[0]["NUP"].ToString();
nova.Text = rs.Rows[0]["NoVA"].ToString();
if (nova.Text != "")
{
btnpop.Disabled = true;
}
}
printSP.HRef = "PrintSP.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"] + "&Priview=0";
printSP2.HRef = "PrintSP.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"] + "&Priview=1";
printPPJB.HRef = "PrintPPJB.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"];
printAJB.HRef = "PrintAJB.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"];
printBAST.HRef = "PrintBAST.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"];
printRKOM.HRef = "PrintRKOM.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"];
printFPS.HRef = "PrintFPS.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"];
printFBatal.HRef = "PrintFBatal.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"];
printJadwalTagihan.HRef = "PrintJadwalTagihan.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"];
}
private void Fill()
{
string strSql = "SELECT * FROM MS_KONTRAK "
+ " WHERE NoKontrak = '" + nomor + "' and Project = '" + proj + "'"
;
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count > 0)
{
nokontrak.Text = rs.Rows[0]["NoKontrak"].ToString();
//tglkontrak.Text = Cf.DayIndo(rs.Rows[0]["TglKontrak"]);
//namaproject.Text = rs.Rows[0]["NamaProject"].ToString();
//namapers.Text = rs.Rows[0]["NamaPers"].ToString();
hargapengikatan.Text = nilaikontrak1.Text = Cf.NumBulat(rs.Rows[0]["NilaiKontrak"]);
carabayar.Text = cara_bayar.Text = cara_bayar1.Text = Db.SingleString("select ISNULL(Nama, '') from REF_SKEMA where Nomor = '" + rs.Rows[0]["Refskema"] + "'");
marketing.Text = marketing2.Text = Db.SingleString("SELECT NAMA FROM MS_AGENT WHERE NoAgent = " + rs.Rows[0]["NoAgent"].ToString());
//fill data customer
int CountCus = Db.SingleInteger("select count(*) from MS_CUSTOMER where NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'");
if (CountCus != 0)
{
string strSqlCus = "";
strSqlCus = "SELECT * FROM MS_CUSTOMER WHERE NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'";
DataTable rsCus = Db.Rs(strSqlCus);
for (int j = 0; j < rsCus.Rows.Count; j++)
{
namacs.Text = namacs2.Text = pemesan.Text = pemesan2.Text = rsCus.Rows[j]["Nama"].ToString();
noktp.Text = rsCus.Rows[j]["NoKTP"].ToString();
npwp.Text = rsCus.Rows[j]["NPWP"].ToString();
alamatktp1.Text = rsCus.Rows[j]["KTP1"].ToString() + " " + rsCus.Rows[j]["KTP2"].ToString() + " " + rsCus.Rows[j]["KTP3"].ToString();
alamatktp2.Text = rsCus.Rows[j]["KTP4"].ToString() + " " + rsCus.Rows[j]["KTP5"].ToString();
// alamatsekarang1.Text = rsCus.Rows[j]["Alamat1"].ToString() + " " + rsCus.Rows[j]["Alamat2"].ToString() + " " + rsCus.Rows[j]["Alamat3"].ToString();
// alamatsekarang2.Text = rsCus.Rows[j]["Alamat4"].ToString() + " " + rsCus.Rows[j]["Alamat5"].ToString();
telpon.Text = rsCus.Rows[j]["NoTelp"].ToString();
noHp.Text = rsCus.Rows[j]["NoHP"].ToString();
// email.Text = rsCus.Rows[j]["Email"].ToString();
//
}
}
//fill data unit
int CountUnit = Db.SingleInteger("select count(*) from MS_UNIT where NoStock = '" + rs.Rows[0]["NoStock"] + "'");
if (CountUnit != 0)
{
string strSqlUnit = "";
string strSqlBooking = "SELECT "
+ "NilaiTagihan"
+ " FROM MS_TAGIHAN"
+ " WHERE NoKontrak = '" + nomor + "'"
+ " AND TIPE = 'BF'";
booking_fee.Text = Cf.Num(Db.SingleDecimal(strSqlBooking));
strSqlUnit = "SELECT * FROM MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'";
DataTable rsUnit = Db.Rs(strSqlUnit);
for (int k = 0; k < rsUnit.Rows.Count; k++)
{
jenisproperti.Text = jenispro2.Text = rsUnit.Rows[k]["JenisProperti"].ToString();
//namajalan.Text = rsUnit.Rows[k]["NamaJalan"].ToString();
lantai_blok_unit.Text = lantai1.Text = rsUnit.Rows[k]["Lantai"].ToString();
lantai_blok_unit2.Text = unit1.Text = rsUnit.Rows[k]["Nomor"].ToString().PadLeft(2, '0');
//jenis.Text = rsUnit.Rows[k]["Jenis"].ToString();
luasbgn.Text = luas_bangun.Text = Cf.Num(rsUnit.Rows[k]["LuasNett"]);
//luassg.Text = Cf.Num(rsUnit.Rows[k]["LuasSG"]);
//lokasi.Text = rsUnit.Rows[k]["Lokasi"].ToString();
}
}
//gimmick
//int CountGimmick = Db.SingleInteger("select count(*) from MS_KONTRAK_GIMMICK where NoKontrak = '" + nomor + "'");
//if (CountGimmick != 0)
//{
// gimmicktr.Visible = true;
// FillTb();
//}
//else
//{
// gimmicktr.Visible = false;
//}
}
}
