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; } } }