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=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()
{
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()
{
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());
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
Act.Pass();
Act.NoCache();
if (!Page.IsPostBack)
{
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");
}
Js.Focus(this, ket);
Js.Confirm(this,
"Apakah anda ingin menghapus account : " + Acc + " ?\\n"
+ "Perhatian bahwa data akan dihapus secara PERMANEN."
);
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
Act.Pass();
Act.NoCache();
if (!Page.IsPostBack)
{
DataTable rs = Db.Rs("SELECT * FROM REF_EMAIL"
+ " WHERE ID = '" + ID + "'"
);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString()))
{
Response.Redirect("/CustomError/SecLevel.html");
}
Js.Focus(this, ket);
Js.Confirm(this,
"Apakah anda ingin menghapus Email : " + rs.Rows[0]["Email"].ToString() + " ?\\n"
+ "Perhatian bahwa data akan dihapus secara PERMANEN."
);
}
}
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"];
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs("SELECT * FROM REF_EMAIL"
+ " WHERE ID = '" + ID + "'"
);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
//frm.Visible = false;
//nodel.Visible = true;
}
else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString()))
{
Response.Redirect("/CustomError/SecLevel.html");
}
else
{
string Ket = "***Alasan Delete :<br>" + Cf.Str(ket.Text)
+ "<br><br>***Data Sebelum Delete :<br>"
+ Cf.LogCapture(rs);
Db.Execute("DELETE FROM REF_EMAIL WHERE ID = '" + ID + "'");
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM REF_EMAIL WHERE ID = '" + ID + "'");
if (c == 0)
{
//Log
Db.Execute("EXEC spLogEmail "
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + ID + "'"
);
Js.Close(this);
}
else
{
//Tidak bisa dihapus
frm.Visible = false;
nodel.Visible = true;
}
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs(
"SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_LEVEL WHERE LevelID = '" + NoLevel + "'");
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
{
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_AGENT WHERE SalesLevel = '" + rs.Rows[0]["LevelID"] + "'");
if (c == 0)
{
string Ket = "***Alasan Delete :<br>" + Cf.Str(ket.Text)
+ "<br><br>***Data Sebelum Delete :<br>"
+ Cf.LogCapture(rs);
Db.Execute("EXEC " + Mi.DbPrefix + "MARKETINGJUAL..spLogLevelSales"
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoLevel + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_LEVEL_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_LEVEL WHERE LevelID = '" + NoLevel + "'");
Db.Execute("UPDATE " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_LEVEL_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Db.Execute("DELETE FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_LEVEL WHERE LevelID = '" + NoLevel + "'");
Js.Close(this);
}
else
{
//Tidak bisa dihapus
frm.Visible = false;
nodel.Visible = true;
}
}
}
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());
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs(
"SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_FOLLOWUP WHERE No = '" + No + "'");
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
{
string Ket = "***Alasan Delete :<br>" + Cf.Str(ket.Text)
+ "<br><br>***Data Sebelum Delete :<br>"
+ Cf.LogCapture(rs);
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_FOLLOWUP WHERE NamaGrouping = '" + rs.Rows[0]["NamaGrouping"] + "'");
if (c == 0)
{
Db.Execute("EXEC " + Mi.DbPrefix + "MARKETINGJUAL..spLogGrouping"
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + No + "'"
);
Db.Execute("DELETE FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_FOLLOWUP WHERE No = '" + No + "'");
Js.Close(this);
}
else
{
//Tidak bisa dihapus
frm.Visible = false;
nodel.Visible = true;
}
}
}
private void Fill()
{
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?tb=ISC064_MARKETINGJUAL..REF_LOKASI_LOG&Pk=" + NoLokasi + "'";
btndel.Attributes["onclick"] = "location.href='LokasiDel.aspx?NoLokasi=" + NoLokasi + "'";
string strSql = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_LOKASI WHERE SN = '" + NoLokasi + "'";
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
{
nolokasi.Text = rs.Rows[0]["SN"].ToString();
lokasi.Text = rs.Rows[0]["Lokasi"].ToString();
namalokasi.Text = rs.Rows[0]["Nama"].ToString();
project.SelectedValue = rs.Rows[0]["Project"].ToString();
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs(
"SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA WHERE Nomor = " + Nomor);
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
{
DataTable rsHeader = Db.Rs("SELECT "
+ " Nomor"
+ ",Nama"
+ ",Diskon"
+ ",RThousand AS [Pembulatan Nilai]"
+ ",Status"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA "
+ " WHERE Nomor = " + Nomor);
DataTable rsDetail = Db.Rs("SELECT "
+ " CONVERT(VARCHAR, Baris) "
+ " + '. ' + Nama + ' (' + Tipe + ') ' "
+ " + TipeNominal + CONVERT(VARCHAR, Nominal, 1) + ' ' "
+ " + TipeJadwal + '(' + CONVERT(VARCHAR, IntJadwal) + ')' + "
+ " ISNULL(CONVERT(VARCHAR, TglFix, 106), 'NULL') + ' ' "
+ " + 'REF:' + CONVERT(VARCHAR,RefJadwal) + ' ' "
+ " + 'BF:' + CONVERT(VARCHAR, BF)"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA_DETAIL WHERE Nomor = " + Nomor);
int cekdigunakan = Db.SingleInteger("select COUNT(distinct(RefSkema)) from " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK inner join " + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA on " + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA.Nomor = MS_KONTRAK.RefSkema"
+ " where " + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA.Nomor = " + Nomor);
if (cekdigunakan == 0)
{
Db.Execute("EXEC " + Mi.DbPrefix + "MARKETINGJUAL..spSkemaDel "
+ Nomor
);
string Ket = "***Alasan Delete :<br>" + Cf.Str(ket.Text)
+ "<br><br>***Data Sebelum Delete :<br>"
+ Cf.LogCapture(rsHeader)
+ Cf.LogList(rsDetail, "RUMUS");
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA WHERE Nomor = " + Nomor);
if (c == 0)
{
Db.Execute("EXEC " + Mi.DbPrefix + "MARKETINGJUAL..spLogSkema"
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + Nomor.PadLeft(3, '0') + "'"
);
Js.Close(this);
}
}
else
{
//Tidak bisa dihapus
frm.Visible = false;
nodel.Visible = true;
}
}
}