private void Tampil()
{
list.Visible = true;
reprint.Visible = false;
Js.AutoPrint(this);
//increment
Db.Execute("UPDATE MS_RESERVASI SET PrintWL = PrintWL + 1 WHERE NoReservasi = " + NoReservasi);
//Logfile
DataTable rs = Db.Rs("SELECT "
+ " MS_RESERVASI.NoUnit AS [Unit]"
+ ",MS_CUSTOMER.Nama AS [Customer]"
+ ",PrintWL AS [Print Counter]"
+ " FROM MS_RESERVASI INNER JOIN MS_CUSTOMER ON MS_RESERVASI.NoCustomer = MS_CUSTOMER.NoCustomer"
+ " WHERE MS_RESERVASI.NoReservasi = " + NoReservasi
);
Db.Execute("EXEC spLogReservasi"
+ " 'P-WL'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Cf.LogCapture(rs) + "'"
+ ",'" + NoReservasi.ToString().PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_RESERVASI_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM MS_UNIT WHERE NoStock = (SELECT NoStock FROM MS_RESERVASI WHERE NoReservasi = '" + NoReservasi + "')");
Db.Execute("UPDATE MS_RESERVASI_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
}
protected void Page_Load(object sender, System.EventArgs e)
{
Act.Pass();
Act.NoCache();
Act.CekInt("NoReservasi");
DataTable rs = Db.Rs(
"SELECT * FROM MS_RESERVASI WHERE NoReservasi = " + NoReservasi);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
DataTable rsDetail = Db.Rs("SELECT "
+ " MS_RESERVASI.NoUnit AS [Unit]"
+ ",MS_RESERVASI.NoStock AS [No. Stock]"
+ ",MS_RESERVASI.NoUrut AS [No. Urut]"
+ ",MS_CUSTOMER.Nama AS [Customer]"
+ ",MS_AGENT.Nama + ' ' + MS_AGENT.Principal AS [Agent]"
+ ",CONVERT(varchar,MS_RESERVASI.Tgl,106) AS [Tanggal]"
+ ",CONVERT(varchar,MS_RESERVASI.TglExpire,100) AS [Batas Waktu]"
+ ",MS_RESERVASI.Netto AS [Nilai Pengikatan]"
+ ",MS_RESERVASI.Skema AS [Skema]"
+ " FROM MS_RESERVASI INNER JOIN MS_CUSTOMER ON MS_RESERVASI.NoCustomer = MS_CUSTOMER.NoCustomer"
+ " INNER JOIN MS_AGENT ON MS_RESERVASI.NoAgent = MS_AGENT.NoAgent"
+ " WHERE MS_RESERVASI.NoReservasi = " + NoReservasi
);
Db.Execute("EXEC spReservasiPromote " + NoReservasi);
//Log
Db.Execute("EXEC spLogReservasi "
+ " 'PWL'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Cf.LogCapture(rsDetail) + "'"
+ ",'" + NoReservasi.ToString().PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_RESERVASI_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM MS_UNIT WHERE NoStock = (SELECT NoStock FROM MS_RESERVASI WHERE NoReservasi = '" + NoReservasi + "')");
Db.Execute("UPDATE MS_RESERVASI_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Response.Redirect("UnitWL.aspx?NoStock=" + rs.Rows[0]["NoStock"]);
}
}
private void Valid(string Username)
{
Session["SalahPass"] = null;
//Logfile otorisasi
DataTable rs = Db.Rs("SELECT "
+ " NoReservasi AS [No. Reservasi]"
+ ",NoUnit AS [Unit]"
+ ",NoUrut AS [No. Urut]"
+ ",NoStock AS [No. Stock]"
+ ",MS_CUSTOMER.Nama AS [Customer]"
+ ",MS_AGENT.Nama + ' ' + MS_AGENT.Principal AS [Agent]"
+ ",CONVERT(varchar,Tgl,106) AS [Tanggal]"
+ ",CONVERT(varchar,TglExpire,100) AS [Batas Waktu]"
+ ",Netto AS [Nilai Pengikatan]"
+ ",MS_RESERVASI.Skema AS [Skema]"
+ ",NoQueue AS [NUP]"
+ ",MS_RESERVASI.NoRefferatorAgent"
+ ",MS_RESERVASI.NoRefferatorCustomer"
+ " FROM MS_RESERVASI INNER JOIN MS_CUSTOMER ON MS_RESERVASI.NoCustomer = MS_CUSTOMER.NoCustomer"
+ " INNER JOIN MS_AGENT ON MS_RESERVASI.NoAgent = MS_AGENT.NoAgent"
+ " WHERE NoReservasi = " + NoReservasi
);
Db.Execute("EXEC spLogReservasi"
+ " 'R-BFORM'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Cf.LogCapture(rs) + "'"
+ ",'" + NoReservasi.ToString().PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_RESERVASI_LOG ORDER BY LogID DESC");
Db.Execute("UPDATE MS_RESERVASI_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Tampil();
//string file = Param.PathFilePDFMarketingJual + NoReservasi.Replace("/", "_").Replace("\\", "_") + Project + "_BF.pdf";
//bool exist = System.IO.File.Exists(file);
//if (exist)
//{
// System.IO.File.Delete(file);
//}
//ConvertPdf();
//Response.Redirect("http://" + Request.Url.Host + ":" + Request.Url.Port
// + Param.PathLinkFilePDFMarketingJual + NoReservasi.Replace("/", "_").Replace("\\", "_") + Project + "_BF.pdf");
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs(
"SELECT * FROM MS_RESERVASI WHERE NoReservasi = " + NoReservasi);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
string Ket = "***Alasan Delete :<br>" + Cf.Str(ket.Text)
+ "<br><br>***Data Sebelum Delete :<br>"
+ Cf.LogCapture(rs);
Db.Execute("EXEC spReservasiDel " + NoReservasi);
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM MS_RESERVASI WHERE NoReservasi = " + NoReservasi);
if (c == 0)
{
//Log
Db.Execute("EXEC spLogReservasi "
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoReservasi.ToString().PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_RESERVASI_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM MS_UNIT WHERE NoStock = (SELECT NoStock FROM MS_RESERVASI WHERE NoReservasi = '" + NoReservasi + "')");
Db.Execute("UPDATE MS_RESERVASI_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Js.Close(this);
}
else
{
//Tidak bisa dihapus
frm.Visible = false;
nodel.Visible = true;
}
}
}
private void Tampil()
{
list.Visible = true;
reprint.Visible = false;
Js.AutoPrint(this);
//increment
Db.Execute("UPDATE MS_RESERVASI SET PrintBForm = PrintBForm + 1 WHERE NoReservasi = '" + NoReservasi + "'");
//Logfile
DataTable rs = Db.Rs("SELECT "
+ " NoReservasi AS [No. Reservasi]"
+ ",NoUnit AS [Unit]"
+ ",NoUrut AS [No. Urut]"
+ ",NoStock AS [No. Stock]"
+ ",MS_CUSTOMER.Nama AS [Customer]"
+ ",MS_AGENT.Nama + ' ' + MS_AGENT.Principal AS [Agent]"
+ ",CONVERT(varchar,Tgl,106) AS [Tanggal]"
+ ",CONVERT(varchar,TglExpire,100) AS [Batas Waktu]"
+ ",Netto AS [Nilai Pengikatan]"
+ ",MS_RESERVASI.Skema AS [Skema]"
+ ",NoQueue AS [NUP]"
+ ",MS_RESERVASI.NoRefferatorAgent"
+ ",MS_RESERVASI.NoRefferatorCustomer"
+ " FROM MS_RESERVASI INNER JOIN MS_CUSTOMER ON MS_RESERVASI.NoCustomer = MS_CUSTOMER.NoCustomer"
+ " INNER JOIN MS_AGENT ON MS_RESERVASI.NoAgent = MS_AGENT.NoAgent"
+ " WHERE NoReservasi = " + NoReservasi
);
Db.Execute("EXEC spLogReservasi"
+ " 'P-BFORM'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Cf.LogCapture(rs) + "'"
+ ",'" + NoReservasi.ToString().PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_RESERVASI_LOG ORDER BY LogID DESC");
Db.Execute("UPDATE MS_RESERVASI_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
}
private void Valid(string Username)
{
Session["SalahPass"] = null;
//Logfile otorisasi
DataTable rs = Db.Rs("SELECT "
+ " MS_RESERVASI.NoUnit AS [Unit]"
+ ",MS_CUSTOMER.Nama AS [Customer]"
+ " FROM MS_RESERVASI INNER JOIN MS_CUSTOMER ON MS_RESERVASI.NoCustomer = MS_CUSTOMER.NoCustomer"
+ " WHERE MS_RESERVASI.NoReservasi = " + NoReservasi
);
Db.Execute("EXEC spLogReservasi"
+ " 'R-WL'"
+ ",'" + Username + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Cf.LogCapture(rs) + "'"
+ ",'" + NoReservasi.ToString().PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_RESERVASI_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM MS_UNIT WHERE NoStock = (SELECT NoStock FROM MS_RESERVASI WHERE NoReservasi = '" + NoReservasi + "')");
Db.Execute("UPDATE MS_RESERVASI_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Tampil();
string file = Param.PathFilePDFMarketingJual + NoReservasi + "_WL.pdf";
bool exist = System.IO.File.Exists(file);
if (exist)
{
System.IO.File.Delete(file);
}
ConvertPdf();
Response.Redirect(Param.PathLinkFilePDFMarketingJual + NoReservasi + "_WL.pdf");
}
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 bool Save()
{
if (valid())
{
string Project = Db.SingleString("SELECT Project FROM MS_UNIT WHERE NoStock = (SELECT NoStock FROM MS_RESERVASI WHERE NoReservasi = '" + NoReservasi + "')");
DateTime Tgl = Convert.ToDateTime(tgl.Text);
DateTime TglExpire = Convert.ToDateTime(batas.Text);
int NoQueue = Convert.ToInt32(noqueue.Text);
decimal Netto = Convert.ToDecimal(nilai.Text);
string Skema = Cf.Str(skema.Text);
int NoAgent = Convert.ToInt32(agent.SelectedValue);
string Supervisor = Cf.Str(supervisor.Text);
string Manager = Cf.Str(manager.Text);
DataTable rsBef = Db.Rs("SELECT"
+ " CONVERT(varchar,MS_RESERVASI.Tgl,106) AS [Tanggal]"
+ ",CONVERT(varchar,MS_RESERVASI.TglExpire,100) AS [Batas Waktu]"
+ ",MS_RESERVASI.Netto AS [Nilai Pengikatan]"
+ ",MS_RESERVASI.Skema AS [Skema]"
+ ",MS_AGENT.Nama + ' ' + MS_AGENT.Principal AS Agent"
+ ",NoQueue AS [NUP]"
+ ",Supervisor AS [Supervisor]"
+ ",MS_AGENT.Manager AS [Manager]"
+ " FROM MS_RESERVASI"
+ " INNER JOIN MS_AGENT"
+ " ON MS_RESERVASI.NoAgent = MS_AGENT.NoAgent"
+ " WHERE NoReservasi = " + NoReservasi
);
Db.Execute("EXEC spReservasiEdit"
+ " " + NoReservasi
+ ", " + NoAgent
+ ",'" + Tgl + "'"
+ ",'" + TglExpire + "'"
+ ", " + Netto
+ ",'" + Skema + "'"
+ ", " + NoQueue
);
Db.Execute("UPDATE MS_RESERVASI SET "
+ " Supervisor ='" + Supervisor + "'"
+ ",Manager ='" + Manager + "'"
+ " WHERE NoReservasi = '" + NoReservasi + "'"
);
DataTable rsAft = Db.Rs("SELECT"
+ " CONVERT(varchar,MS_RESERVASI.Tgl,106) AS [Tanggal]"
+ ",CONVERT(varchar,MS_RESERVASI.TglExpire,100) AS [Batas Waktu]"
+ ",MS_RESERVASI.Netto AS [Nilai Pengikatan]"
+ ",MS_RESERVASI.Skema AS [Skema]"
+ ",MS_AGENT.Nama + ' ' + MS_AGENT.Principal AS Agent"
+ ",NoQueue AS [NUP]"
+ ",Supervisor AS [Supervisor]"
+ ",MS_AGENT.Manager AS [Manager]"
+ " FROM MS_RESERVASI"
+ " INNER JOIN MS_AGENT"
+ " ON MS_RESERVASI.NoAgent = MS_AGENT.NoAgent"
+ " WHERE NoReservasi = " + NoReservasi
);
Db.Execute("EXEC spLogReservasi"
+ " 'EDIT'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Cf.LogCompare(rsBef, rsAft) + "'"
+ ",'" + NoReservasi.ToString().PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_RESERVASI_LOG ORDER BY LogID DESC");
Db.Execute("UPDATE MS_RESERVASI_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
return(true);
}
else
{
return(false);
}
}
private void FillTb()
{
string strSql = "SELECT "
+ " NamaTagihan"
+ ",TglJT"
+ ",NilaiTagihan"
+ ",NoUrut"
+ ",Tipe"
+ " FROM ISC064_MARKETINGJUAL..MS_RESERVASI_TAGIHAN"
+ " WHERE NoReservasi = '" + NoReservasi + "'"
+ " ORDER BY NoUrut";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Daftar tagihan untuk kontrak tersebut masih kosong.");
decimal t1 = 0;
decimal t2 = 0;
decimal t3 = 0;
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
t1 = t1 + (decimal)rs.Rows[i]["NilaiTagihan"];
//t2 = t2 + (decimal)rs.Rows[i]["SisaTagihan"];
c = new TableCell();
c.Text = NoReservasi.PadLeft(5, '0') + "." + rs.Rows[i]["NoUrut"];
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Tipe"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NamaTagihan"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["TglJT"]);
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(rs.Rows[i]["NilaiTagihan"]);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = new TableCell();
c.Text = "";
r.Cells.Add(c);
//c = new TableCell();
//c.Text = Cf.Num(rs.Rows[i]["SisaTagihan"]);
//c.HorizontalAlign = HorizontalAlign.Right;
//r.Cells.Add(c);
// c = new TableCell();
// c.Text = "<a href='PrintINV.aspx?NoKontrak=" + NoKontrak + "&NoUrut=" + rs.Rows[i]["NoUrut"] + "'>Invoice...</a>";
// r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
//t3 = t3 + Lunas((int)rs.Rows[i]["NoUrut"]);
if (i == rs.Rows.Count - 1)
{
SubTotal(t1, t2, t3);
}
}
// Lunas(0);
}
