protected void upload_Click(object sender, System.EventArgs e) { namapeta.Text = Cf.FileSafe(namapeta.Text); if (namapeta.Text == "" || !file1.PostedFile.FileName.EndsWith(".jpg")) { Js.Alert( this , "Proses Upload Gagal.\\n" + "1. Nama Peta tidak boleh kosong.\\n" + "2. Extension file peta utama hanya boleh JPG.\\n" //+ "3. Extension file peta nomor hanya boleh PNG\\n" , "document.getElementById('namapeta').focus();" + "document.getElementById('namapeta').select();" ); } else { string NamaPeta = Cf.FileSafe(namapeta.Text); string pdasar = Request.PhysicalApplicationPath.Replace("admin", "marketing") + "FP\\Base\\" + Tower + "\\" + NamaPeta + ".jpg"; //file dasar string pstatus = Request.PhysicalApplicationPath.Replace("admin", "marketing") + "FP\\" + NamaPeta + ".jpg"; //file status //string pnomor = Request.PhysicalApplicationPath.Replace("admin", "marketing") // + "FP\\" + NamaPeta + ".png"; //file nomor Dfc.UploadFile(".jpg", pdasar, file1); //Dfc.UploadFile(".png", pnomor, file2); Dfc.CopyFile(pdasar, pstatus);//Copy dari base ke status //Logfile string Ket = "***UPLOAD FLOOR PLAN : " + NamaPeta; Db.Execute("EXEC spLogUnit" + " 'FP'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Ket + "'" + ",''" ); feed.Text = "<img src='/Media/db.gif' align=absmiddle> " + "Upload Berhasil..."; } }
protected void Page_Load(object sender, System.EventArgs e) { Act.Pass(); Act.NoCache(); if (File.Exists(Request.PhysicalApplicationPath + "FP\\UnitLokasi\\" + Cf.FileSafe(NoUnit) + ".jpg")) { unit.ImageUrl = "PetaBesar.aspx?f=FP/UnitLokasi/" + Cf.FileSafe(NoUnit) + ".jpg"; noimg.Visible = false; } else { unit.Visible = false; noimg.Visible = true; } }
/// <summary> /// Redrawing process /// </summary> public static void GenerateFP(string Peta) { if (Peta != "") { string loc = System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "FP\\"; string Src = loc + "Base\\" + Cf.FileSafe(Peta) + ".jpg"; string Target = loc + Cf.FileSafe(Peta) + ".jpg"; if (System.IO.File.Exists(Src)) { Bitmap objBitmap = new Bitmap(Src); Graphics objGraphics = Graphics.FromImage(objBitmap); string strSql = "SELECT Status, Koordinat, NoStock" + " FROM MS_UNIT " + " WHERE Peta = '" + Peta + "'"; DataTable rs = Db.Rs(strSql); for (int i = 0; i < rs.Rows.Count; i++) { if (!System.Web.HttpContext.Current.Response.IsClientConnected) { break; } string Coordinate = rs.Rows[i]["Koordinat"].ToString(); string status = rs.Rows[i]["Status"].ToString(); string NoStock = rs.Rows[i]["NoStock"].ToString(); string[] arrCoordinate = Coordinate.Split(new char[] { ',' }); System.Collections.ArrayList myPointList = new System.Collections.ArrayList(); for (int ix = 0; ix < arrCoordinate.GetUpperBound(0); ix = ix + 2) { myPointList.Add(new Point( Convert.ToInt32(arrCoordinate[ix]) , Convert.ToInt32(arrCoordinate[ix + 1]))); } Point[] ArrPoint = new Point[myPointList.Count]; for (int jx = 0; jx < myPointList.Count; jx++) { ArrPoint[jx] = (Point)myPointList[jx]; } Color ColorPoly = new Color(); Color myColor = Color.FromArgb(50, Color.White); if (status == "B") { int c = Db.SingleInteger("SELECT COUNT(*) FROM MS_KONTRAK WHERE Status = 'A' AND NoStock = '" + NoStock + "'"); if (c != 0) { ColorPoly = Color.Red; //sold } else { ColorPoly = Color.Orange; //hold internal } } else { int c = Db.SingleInteger("SELECT COUNT(*) FROM MS_RESERVASI WHERE Status = 'A' AND NoStock = '" + NoStock + "'"); if (c != 0) { ColorPoly = Color.Blue; //booked } else { ColorPoly = Color.Green; //available } } objGraphics.FillPolygon( new HatchBrush(HatchStyle.DarkUpwardDiagonal, ColorPoly, myColor) , ArrPoint); } objBitmap.Save(Target); objGraphics.Dispose(); objBitmap.Dispose(); } } }
/// <summary> /// Redrawing process /// </summary> public static void GenerateFP(string Peta) { if (Peta != "") { string loc = System.Web.HttpContext.Current.Request.PhysicalApplicationPath.Replace("admin", "marketing") + "FP\\"; string Src = loc + "Base\\" + Cf.FileSafe(Peta) + ".jpg"; string Target = loc + Cf.FileSafe(Peta) + ".jpg"; if (System.IO.File.Exists(Src)) { Bitmap objBitmap = new Bitmap(Src); Graphics objGraphics = Graphics.FromImage(objBitmap); string strSql = "SELECT Status, Koordinat" + " FROM MS_UNIT " + " WHERE Peta = '" + Peta + "'"; DataTable rs = Db.Rs(strSql); for (int i = 0; i < rs.Rows.Count; i++) { if (!System.Web.HttpContext.Current.Response.IsClientConnected) { break; } string Coordinate = rs.Rows[i]["Koordinat"].ToString(); string status = rs.Rows[i]["Status"].ToString(); string[] arrCoordinate = Coordinate.Split(new char[] { ',' }); System.Collections.ArrayList myPointList = new System.Collections.ArrayList(); for (int ix = 0; ix < arrCoordinate.GetUpperBound(0); ix = ix + 2) { myPointList.Add(new Point( Convert.ToInt32(arrCoordinate[ix]) , Convert.ToInt32(arrCoordinate[ix + 1]))); } Point[] ArrPoint = new Point[myPointList.Count]; for (int jx = 0; jx < myPointList.Count; jx++) { ArrPoint[jx] = (Point)myPointList[jx]; } if (status == "B") { Color ColorPoly = new Color(); ColorPoly = Color.Red; Color myColor = Color.FromArgb(100, Color.White); objGraphics.FillPolygon( new HatchBrush(HatchStyle.ForwardDiagonal, ColorPoly, myColor) , ArrPoint); } } objBitmap.Save(Target); objGraphics.Dispose(); objBitmap.Dispose(); } } }
protected void save_Click(object sender, System.EventArgs e) { if (datavalid() && BFLunas()) { DateTime TglPPJB = new DateTime(); DateTime TglSuratKuasa = new DateTime(); DateTime TglSuratPersetujuan = new DateTime(); if (tglppjb.Text != "") { TglPPJB = Convert.ToDateTime(tglppjb.Text); } if (tglskuasa.Text != "") { TglSuratKuasa = Convert.ToDateTime(tglskuasa.Text); } if (tglspersetujuan.Text != "") { TglSuratPersetujuan = Convert.ToDateTime(tglspersetujuan.Text); } string Sebagai = Cf.Str(seb.SelectedValue); string kAkta = Cf.Str(Cf.FileSafe(akta.Text)); string kSK = Cf.Str(Cf.FileSafe(nosk.Text)); string kNama = Cf.Str(Cf.FileSafe(nama.Text)); string kKedudukan = Cf.Str(Cf.FileSafe(kedudukan.Text)); string kAlamat = Cf.Str(Cf.FileSafe(alamat.Text)); string kRT = Cf.Str(Cf.FileSafe(rt.Text)); string kRW = Cf.Str(Cf.FileSafe(rw.Text)); string kKel = Cf.Str(Cf.FileSafe(kel.Text)); string kKec = Cf.Str(Cf.FileSafe(kec.Text)); string kKomad = Cf.Str(Cf.FileSafe(komad.Text)); string kProv = Cf.Str(Cf.FileSafe(prov.Text)); string NoPPJB = Db.SingleString("SELECT NoPPJB FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'"); if (NoPPJB == "") { NoPPJB = AutoID(); } Db.Execute("EXEC spKontrakPPJB " + " '" + NoKontrak + "'" + ",'" + NoPPJB + "'" + ",'" + TglPPJB + "'" ); //Notes : Data-data PPJB ini dibuat by request, tapi pada akhirnya tidak digunakan. (Per 10 Juni 2015 - Himawan) Db.Execute("UPDATE MS_KONTRAK" + " SET NilaiRealisasiKPR = " + Convert.ToDecimal(nilaikpa.Text) + ", RekeningCairKPR = '" + rekcair.SelectedValue + "'" + ", PPJBSuratKuasaTgl = '" + TglSuratKuasa + "'" + ", PPJBSuratPersetujuanTgl = '" + TglSuratPersetujuan + "'" + ", PPJBSebagai = '" + Sebagai + "'" + ", PPJBSebagaiNoAkta = '" + kAkta + "'" + ", PPJBSebagaiNoSK = '" + kSK + "'" + ", PPJBSebagaiNama = '" + kNama + "'" + ", PPJBSebagaiKedudukan = '" + kKedudukan + "'" + ", PPJBSebagaiAlamat = '" + kAlamat + "'" + ", PPJBSebagaiRT = '" + kRT + "'" + ", PPJBSebagaiRW = '" + kRW + "'" + ", PPJBSebagaiKel = '" + kKel + "'" + ", PPJBSebagaiKec = '" + kKec + "'" + ", PPJBSebagaiKomad = '" + kKomad + "'" + ", PPJBSebagaiProv = '" + kProv + "'" + " WHERE NoKontrak = '" + NoKontrak + "'" ); DataTable rs = Db.Rs("SELECT" + " MS_KONTRAK.NoKontrak AS [No. Kontrak]" + ",MS_KONTRAK.NoUnit AS [Unit]" + ",MS_CUSTOMER.Nama AS [Customer]" + ",NoPPJB AS [No. PPJB]" + ",CONVERT(varchar, TglPPJB, 106) AS [Tanggal PPJB]" + ",PersenLunas AS [Prosentase Pelunasan]" + " FROM MS_KONTRAK INNER JOIN MS_CUSTOMER" + " ON MS_KONTRAK.NoCustomer = MS_CUSTOMER.NoCustomer" + " WHERE MS_KONTRAK.NoKontrak = '" + NoKontrak + "'"); decimal NilaiBiaya = Convert.ToDecimal(nilaibiaya.Text); if (NilaiBiaya != 0) { Db.Execute("EXEC spTagihanDaftar " + " '" + NoKontrak + "'" + ",'BIAYA ADM. PPJB'" + ",'" + TglPPJB + "'" + ", " + NilaiBiaya + ",'ADM'" ); } string ket = Cf.LogCapture(rs) + "<br>Biaya Administrasi : " + Cf.Num(NilaiBiaya) ; Db.Execute("EXEC spLogKontrak " + " 'PPJB'" + ",'" + 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); if (dariReminder.Checked) { Response.Redirect("ReminderPPJB.aspx?done=" + NoKontrak); } else { Response.Redirect("KontrakPPJB.aspx?done=" + NoKontrak); } } }