protected void ok_Click(object sender, System.EventArgs e)
{
if (Save())
{
Js.Close(this);
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs("SELECT * FROM REF_ADMIN_LAUNCHING WHERE id = '" + MyID + "'");
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
Db.Execute("DELETE REF_ADMIN_LAUNCHING WHERE ID= '" + MyID + "'");
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM REF_ADMIN_LAUNCHING WHERE ID = '" + MyID + "'");
if (c == 0)
{
Js.Close(this);
}
else
{
//Tidak bisa dihapus
frm.Visible = false;
nodel.Visible = true;
}
}
protected void ok_Click(object sender, System.EventArgs e)
{
if (filevalid())
{
if (file.PostedFile.FileName.Length != 0)
{
DataTable rsBef = Db.Rs("SELECT "
+ " Foto"
+ " FROM USERNAME WHERE UserID = '" + UserID + "'");
string path = Request.PhysicalApplicationPath + "Foto\\" + UserID + ".png";
string save = "security\\Foto\\" + UserID + ".png";
Dfc.UploadFile(".jpg", path, file);
Db.Execute("UPDATE USERNAME SET Foto ='" + save + "' WHERE UserID = '" + UserID + "'");
DataTable rsAft = Db.Rs("SELECT "
+ " Foto"
+ " FROM USERNAME WHERE UserID = '" + UserID + "'");
string Ket = Cf.LogCompare(rsBef, rsAft);
Db.Execute("EXEC spLogUsername "
+ " 'EDU'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + UserID + "'"
);
}
Js.Close(this);
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs(
"SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_GIMMICK WHERE ItemID = '" + ID + "'");
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>";
Db.Execute("DELETE FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_GIMMICK WHERE ItemID = '" + ID + "'");
//Log
Db.Execute("EXEC " + Mi.DbPrefix + "MARKETINGJUAL..spLogGimmick "
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + ID + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_GIMMICK_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_GIMMICK WHERE ItemID = '" + ID + "'");
Db.Execute("UPDATE " + Mi.DbPrefix + "MARKETINGJUAL..MS_GIMMICK_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Js.Close(this);
}
}
private void SendSMS()
{
SMSLunas();
SMSMinusTujuh();
UlangTahun();
Js.Close(this);
}
protected void save_Click(object sender, EventArgs e)
{
//Save();
if (Save())
Js.Close(this);
//Response.Redirect("HtmlEditorEdit.aspx?done=1&id=" + Halaman);
}
private bool Save()
{
if (valid())
{
if (rumus.SelectedValue == "UNIT")
{
if (validform1)
{
EditLoger(Nomor);
Js.Close(this);
}
}
else
{
if (validform2)
{
EditLoger(Nomor);
Js.Close(this);
}
}
return(true);
}
else
{
return(false);
}
}
protected void ok_Click(object sender, System.EventArgs e)
{
if (valid())
{
int ada = Db.SingleInteger("SELECT COUNT(*) FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE WHERE Tipe='" + tipe.Text + "' AND ID != " + NoTipe);
if (ada > 0)
{
string s = "";
Js.Alert(
this
, "Input Tidak Valid.\\n\\n"
+ "Aturan Proses :\\n"
+ "1. Tipe Sales tidak boleh kosong.\\n"
+ "2. Tipe Sales Duplikat.\\n"
, "document.getElementById('" + s + "').focus();"
+ "document.getElementById('" + s + "').select();"
);
}
else
{
string strSql = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE WHERE ID = '" + NoTipe + "'";
DataTable rs = Db.Rs(strSql);
DataTable rsBef = Db.Rs("SELECT "
+ " Tipe"
+ ",Project"
+ ",ID"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE "
+ " WHERE ID = '" + NoTipe + "'");
//relasi
//Db.Execute("UPDATE " + Mi.DbPrefix + "MARKETINGJUAL..MS_RESERVASI SET Jenis='" + jenis.Text + "' WHERE Jenis='" + rs.Rows[0]["Jenis"] + "'");
Db.Execute("UPDATE " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE SET Tipe='" + tipe.Text + "', Project = '" + project.SelectedValue + "' WHERE ID = '" + NoTipe + "'");
DataTable rsAft = Db.Rs("SELECT "
+ " Tipe"
+ ",Project"
+ ",ID"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE "
+ " WHERE ID = '" + NoTipe + "'");
//Logfile
string Ket = "Tipe: " + tipe.Text + "<br>"
+ Cf.LogCompare(rsBef, rsAft);
Db.Execute("EXEC " + Mi.DbPrefix + "MARKETINGJUAL..spLogTipeSales"
+ " 'EDIT'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoTipe + "'"
);
Js.Close(this);
}
}
}
protected void ok_Click(object sender, System.EventArgs e)
{
if (valid())
{
Db.Execute("update ms_agent_level set nama='" + nama.Text + "' where LevelID='" + Levelid + "'");
Js.Close(this);
Response.Redirect("AgentLevelDaftar.aspx?done=1");
}
Js.Close(this);
}
protected void save_Click(object sender, EventArgs e)
{
if (Valid)
{
byte aaa = 0;
if (tipe.SelectedIndex == 0)
{
aaa = 1;
}
Db.Execute("EXEC spSitePlanDaftar"
+ " '" + ParentID + "'"
+ ",'" + namapeta.Text + "'"
+ ", " + aaa
+ ",''"
+ ",''"
);
//ExecMkt.spSitePlanDaftar(ParentID, namapeta.Text,tipe.SelectedIndex == 0, "", "");
var ID = Db.SingleInteger("Select ISNULL(Max(ID),0) from MS_Siteplan");
Db.Execute("UPDATE MS_SITEPLAN SET Project='" + project.SelectedValue + "' WHERE ID = '" + ID + "'");
var Project = Db.SingleString("Select Project from MS_Siteplan WHERE ParentID = '" + ParentID + "'");
string NamaPeta = "PETA_" + ID;
string pdasar = Request.PhysicalApplicationPath.ToLower().Replace("admin", "marketing")
+ "FP\\Base\\" + NamaPeta + ".jpg"; //file dasar
string ptransparent = Request.PhysicalApplicationPath.ToLower().Replace("admin", "marketing")
+ "FP\\Base\\" + NamaPeta + ".png"; //file dasar
string pstatus = Request.PhysicalApplicationPath.ToLower().Replace("admin", "marketing")
+ "FP\\" + NamaPeta + ".jpg"; //file status
string urlpdasar = @"\marketingjual\FP\Base\" + NamaPeta + ".jpg"; //file dasar
string urlptransparent = @"\marketingjual\FP\Base\" + NamaPeta + ".png"; //file dasar
string urlpstatus = @"\marketingjual\FP\" + NamaPeta + ".jpg"; //file status
if (file1.HasFile)
{
Dfc.UploadFilePeta(".jpg", pdasar, file1);
Dfc.CopyFile(pdasar, pstatus);
Db.Execute("update ms_siteplan set PathGambarDasar='" + urlpdasar + "' where ID='" + ID + "'");
Db.Execute("update ms_siteplan set Project='" + Project + "' where ID='" + ID + "'");
}
//if (file2.HasFile)
//{
// Dfc.UploadFile(".png", ptransparent, file2);
// Db.Execute("update ms_siteplan set PathGambarTransparent='" + urlptransparent + "' where ID='" + ID + "'");
//}
Js.Close(this);
}
}
private bool Save()
{
if (valid())
{
DataTable rs = Db.Rs("SELECT * FROM MS_KOMISIR WHERE NoKomisiR = '" + Nomor + "'");
if (rs.Rows.Count > 0)
{
DataTable rsBef = Db.Rs("SELECT [Tgl] as [Tgl. Realisasi] "
+ " ,[Ket] as [Keterangan]"
+ " FROM MS_KOMISIR where NoKomisiR = '" + Nomor + "'");
DateTime Tgl = Convert.ToDateTime(tgl.Text);
Db.Execute("EXEC spKomisiREdit"
+ " '" + Nomor + "'"
+ ",'" + Tgl + "'"
+ ",'" + ket.Text + "'"
);
DataTable rsAft = Db.Rs("SELECT [Tgl] as [Tgl. Realisasi] "
+ " ,[Ket] as [Keterangan]"
+ " FROM MS_KOMISIR WHERE NoKomisiR = '" + Nomor + "'");
string Ket = "Kode Realisasi : " + Nomor + "<br>"
+ Cf.LogCompare(rsBef, rsAft);
Db.Execute("EXEC spLogKomisiR"
+ " 'EDIT'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + Nomor + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KOMISIR_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM MS_KOMISIR_LOG WHERE NoKomisiP = " + rs.Rows[0]["NoKomisiR"].ToString());
Db.Execute("UPDATE MS_KOMISIR_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Js.Close(this);
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
protected void save_Click(object sender, System.EventArgs e)
{
string statusLama = Db.SingleString("SELECT Status FROM MS_UNIT WHERE NoStock = '" + NoStock + "'");
string statusBaru = "";
if (statusA.Checked)
{
statusBaru = "A";
}
if (statusB.Checked)
{
statusBaru = "B";
}
if (statusC.Checked)
{
statusBaru = "H";
}
if (statusBaru != statusLama)
{
Db.Execute("EXEC spUnitEditStatus "
+ " '" + NoStock + "'"
+ ",'" + statusBaru + "'"
);
string Ket = "<br>***EDIT STATUS : " + statusLama + " --> " + statusBaru;
Db.Execute("EXEC spLogUnit "
+ " 'STATUS'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoStock + "'"
);
//redraw floor plan
string Peta = Db.SingleString("SELECT Peta FROM MS_UNIT WHERE NoStock='" + NoStock + "'");
Func.GenerateFP(Peta);
ClientScript.RegisterStartupScript(GetType(), "closerfr"
, "<script type='text/javascript'>"
+ " window.opener.location.href='UnitEdit.aspx?done=1&NoStock=" + NoStock + "';"
+ " window.close();"
+ "</script>"
);
}
else
{
Js.Close(this);
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
string[] x = Cf.SplitByString(Acc, ";");
DataTable rs = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "FINANCEAR..MS_TTS"
+ " WHERE Acc ='" + x[0] + "' AND SubID='" + x[1] + "'"
);
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("EXEC " + Mi.DbPrefix + "FINANCEAR..spAccDel '" + x[0] + "', '" + x[1] + "'");
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM " + Mi.DbPrefix + "FINANCEAR..REF_ACC WHERE Acc = '" + x[0] + "' AND SubID='" + x[1] + "'");
if (c == 0)
{
//Log
Db.Execute("EXEC " + Mi.DbPrefix + "FINANCEAR..spLogAcc "
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + Acc + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM REF_ACC_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM REF_ACC WHERE Acc ='" + x[0] + "' AND SubID='" + x[1] + "'");
Db.Execute("UPDATE REF_ACC_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
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 MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'");
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);
string Peta = Db.SingleString("SELECT Peta "
+ " FROM MS_UNIT INNER JOIN MS_KONTRAK ON MS_UNIT.NoStock = MS_KONTRAK.NoStock "
+ " WHERE NoKontrak = '" + NoKontrak + "'");
Db.Execute("EXEC spKontrakDel '" + NoKontrak + "'");
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'");
if (c == 0)
{
//redraw floor plan
Func.GenerateFP(Peta);
//Log
Db.Execute("EXEC spLogKontrak "
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoKontrak + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KONTRAK_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'");
Db.Execute("UPDATE MS_KONTRAK_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Js.Close(this);
}
else
{
//Tidak bisa dihapus
frm.Visible = false;
nodel.Visible = true;
}
}
}
private bool Save()
{
if (valid() && validform1 && validcair)
{
EditLoger(Nomor);
Js.Close(this);
return(true);
}
else
{
return(false);
}
}
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;
}
}
}
private bool Save()
{
if (valid())
{
DataTable rs = Db.Rs("SELECT * FROM MS_KOMISI_CFR WHERE NoCFR = '" + Nomor + "'");
if (rs.Rows.Count > 0)
{
DataTable rsBef = Db.Rs("SELECT [Tgl] as [Tgl. Realisasi] "
+ " ,[Ket] as [Keterangan]"
+ " FROM MS_KOMISI_CFR where NoCFR = '" + Nomor + "'");
DateTime Tgl = Convert.ToDateTime(tgl.Text);
Db.Execute("EXEC spKomisiCFREdit"
+ " '" + Nomor + "'"
+ ",'" + Tgl + "'"
+ ",'" + ket.Text + "'"
);
DataTable rsAft = Db.Rs("SELECT [Tgl] as [Tgl. Realisasi] "
+ " ,[Ket] as [Keterangan]"
+ " FROM MS_KOMISI_CFR WHERE NoCFR = '" + Nomor + "'");
string Ket = "Kode Realisasi : " + Nomor + "<br>"
+ Cf.LogCompare(rsBef, rsAft);
Db.Execute("EXEC spLogKomisiCFR"
+ " 'EDIT'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + Nomor + "'"
);
Js.Close(this);
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs(
"select * from ISC064_marketingjual..ms_followup where NoFU = '" + NoFU + "' and NoKontrak ='" + Ref + "' ");
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 ISC064_marketingjual..spFUDel "
+ "'" + NoFU + "'"
+ ",'" + Ref + "'"
);
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM ISC064_MARKETINGJUAL..MS_FOLLOWUP WHERE NoFU = " + NoFU + " and NoKontrak = '" + Ref + "'");
if (c == 0)
{
//Log
Db.Execute("EXEC ISC064_MARKETINGJUAL..spLogFU "
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoFU.PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_FOLLOWUP_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = '" + Ref + "'");
Db.Execute("UPDATE " + Mi.DbPrefix + "MARKETINGJUAL..MS_FOLLOWUP_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
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;
}
}
}
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;
}
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs("SELECT * FROM SECLEVEL WHERE Kode = '" + Kode + "'");
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
DataTable rsDetil = Db.Rs("SELECT PAGE.Modul + ' ' + PAGE.Nama + ' ' + PAGE.Halaman"
+ " FROM PAGESEC INNER JOIN PAGE ON PAGESEC.Halaman = PAGE.Halaman "
+ " WHERE Kode = '" + Kode + "' ORDER BY Modul,Nama");
string Ket = "***Alasan Delete :<br>" + Cf.Str(ket.Text)
+ "<br><br>***Data Sebelum Delete :<br>"
+ Cf.LogCapture(rs)
+ Cf.LogList(rsDetil, "KONFIGURASI SECURITY");
Db.Execute("EXEC spSecLevelDel '" + Kode + "'");
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM SECLEVEL WHERE Kode = '" + Kode + "'");
if (c == 0)
{
//Log
Db.Execute("EXEC spLogSeclevel "
+ " 'DEL'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + Kode + "'"
);
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 REF_BANKKPA WHERE KodeBank = '" + Acc + "' AND Project = '" + Project + "'");
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 spBankKPADel"
+ " '" + Acc + "'"
+ ",'" + Project + "'");
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM REF_BANKKPA WHERE KodeBank = '" + Acc + "' AND Project = '" + Project + "'");
if (c == 0)
{
//Log
Db.Execute("EXEC spLogBankKPA "
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + Acc + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM REF_BANKKPA_LOG ORDER BY LogID DESC");
Db.Execute("UPDATE REF_BANKKPA_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
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_BERKAS_PPJB WHERE SN = '" + NoBerkas + "'");
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);
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_BERKAS_PPJB WHERE Nama = '" + rs.Rows[0]["Nama"] + "' AND Project = '" + rs.Rows[0]["Project"] + "'");
if (c != 0)
{
Db.Execute("EXEC " + Mi.DbPrefix + "MARKETINGJUAL..spLogBerkasPPJB"
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoBerkas + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_BERKAS_PPJB_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_BERKAS_PPJB WHERE SN = '" + NoBerkas + "'");
Db.Execute("UPDATE " + Mi.DbPrefix + "MARKETINGJUAL..REF_BERKAS_PPJB_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Db.Execute("DELETE FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_BERKAS_PPJB WHERE SN = '" + NoBerkas + "'");
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_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;
}
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs(
"SELECT * FROM MS_COMPLAIN WHERE NoComplain = " + NoComplain);
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 spComplaintDel " + NoComplain);
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM MS_COMPLAIN WHERE NoComplain = " + NoComplain);
if (c == 0)
{
//Log
//Db.Execute("EXEC spLogAgent "
// + " 'DELETE'"
// + ",'" + Act.UserID + "'"
// + ",'" + Act.IP + "'"
// + ",'" + Ket + "'"
// + ",'" + NoComplain.PadLeft(5, '0') + "'"
// );
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 MS_KONTRAK_GIMMICK WHERE NoKontrak = '" + NoKontrak + "' AND SN = " + NoUrut);
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>"
+ NoKontrak + " " + NoUrut + " " + rs.Rows[0]["ItemID"].ToString() + " " + rs.Rows[0]["Nama"].ToString() + " " + rs.Rows[0]["Tipe"].ToString() + " "
+ rs.Rows[0]["Satuan"].ToString() + " " + Cf.Num(rs.Rows[0]["Stock"]) + " " + Cf.Num(rs.Rows[0]["HargaSatuan"]) + " " + Cf.Num(rs.Rows[0]["HargaTotal"]);
Db.Execute("DELETE FROM MS_KONTRAK_GIMMICK WHERE NoKontrak = '" + NoKontrak + "' AND SN = " + NoUrut);
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM MS_KONTRAK_GIMMICK WHERE NoKontrak = '" + NoKontrak + "' AND SN = " + NoUrut);
if (c == 0)
{
//Log
Db.Execute("EXEC spLogKontrak "
+ " 'D-Gi'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoKontrak + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KONTRAK_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'");
Db.Execute("UPDATE MS_KONTRAK_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Js.Close(this);
}
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs(
"SELECT * FROM USERNAME WHERE UserID = '" + UserID + "'");
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
string Ket = "***Alasan Delete :<br>" + Cf.Str(ket.Text)
+ "<br><br>***Data Sebelum Delete :<br>"
+ Cf.LogCapture(rs);
Db.Execute("EXEC spUserDel '" + UserID + "'");
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM USERNAME WHERE UserID = '" + UserID + "'");
if (c == 0)
{
//Log
Db.Execute("EXEC spLogUsername "
+ " 'DEL'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + UserID + "'"
);
Js.Close(this);
}
else
{
//Tidak bisa dihapus
frm.Visible = false;
nodel.Visible = true;
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
Act.Pass();
Act.NoCache();
var rs = Db.Rs("Select * from MS_siteplan where id='" + Idx + "'");
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
string FileName1 = Request.PhysicalApplicationPath.ToLower() + @"\marketingjual\FP\Base\" + Idx + ".jpg";
string FileName2 = Request.PhysicalApplicationPath.ToLower() + @"\marketingjual\FP\Base\" + Idx + ".png";
if (File.Exists(FileName1))
{
File.Delete(FileName1);
}
if (File.Exists(FileName2))
{
File.Delete(FileName2);
}
Db.Execute("Delete MS_siteplan where ID='" + Idx + "'");
//Logfile
string Ket = "---DELETE FLOOR PLAN---<br>"
+ rs.Rows[0]["Nama"]
;
Db.Execute("EXEC spLogUnit"
+ " 'FP'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",''"
);
Js.Close(this);
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs(
"SELECT * FROM REF_LOKASI WHERE SN = '" + NoLokasi + "'");
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);
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM MS_UNIT WHERE Lokasi = '" + rs.Rows[0]["Lokasi"] + "'");
if (c == 0)
{
Db.Execute("EXEC spLogLokasi"
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoLokasi + "'"
);
Db.Execute("DELETE FROM REF_LOKASI WHERE SN = '" + NoLokasi + "'");
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_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;
}
}
}