public void DeleteRecord(PdfFileInfo fileInf) { try { OracleParameter[] delParameters = new OracleParameter[2]; delParameters[0] = new OracleParameter(":RELATION_OBJECT", fileInf.RelationObject); delParameters[1] = new OracleParameter(":RELATION_ID", fileInf.RelationId); string delExtra = ""; if (fileInf.Name.IndexOf("UA") != -1) { delExtra = " AND SH0RT_FILE_NAME LIKE '%UA%' "; } if (fileInf.Name.IndexOf("OG") != -1) { delExtra = " AND SH0RT_FILE_NAME LIKE '%OG%' "; } if (fileInf.Name.IndexOf("UGTL") != -1) { delExtra = string.Format(" AND SH0RT_FILE_NAME = '{0}' ", fileInf.Name); } Exec("DELETE FROM GNLD_UPLOAD_FILE WHERE RELATION_OBJECT = :RELATION_OBJECT AND RELATION_ID = :RELATION_ID " + delExtra, delParameters); } catch (Exception exception) { Logger.E(string.Concat("Öncei dökümanlar silinemedi! Message:" + exception.Message, ",StackTrace:", exception.StackTrace)); } }
private void btnSend_Click(object sender, EventArgs e) { try { if (listView.SelectedIndices.Count > 0) { int oid = Convert.ToInt32(listView.Items[listView.SelectedIndices[0]].Text); if (Utility.Sor(oid + " nolu kayıt gönderilmedi olarak güncellenecek, kabul ediyor musunuz?")) { PdfFileInfo file = XpoDefault.Session.GetObjectByKey <PdfFileInfo>(oid); if (file != null) { file.FileType = PdfFileType.Bilinmiyor; file.UploadMsg = ""; file.Aktarim = AktarimDurumu.Bekliyor; file.Save(); } Dosyalar(); } } } catch (Exception exc) { Utility.Hata(exc); } }
public int InsertRecord(PdfFileInfo fileInf) { try { int uploadFileId = 1; object objIds = ExecuteScalar("SELECT MAX(UPLOAD_FILE_ID) AS UPLOAD_FILE_ID FROM GNLD_UPLOAD_FILE", null); if (objIds != null && object.ReferenceEquals(objIds, DBNull.Value) == false) { uploadFileId = Convert.ToInt32(objIds) + 1; } string commandText = "INSERT INTO GNLD_UPLOAD_FILE (UPLOAD_FILE_ID, RELATION_OBJECT, RELATION_ID, SH0RT_FILE_NAME, LONG_FILE_NAME, DOCUMENT_TYPE, DESCRIPTION, CREATE_DATE, CREATE_USER_ID) VALUES (:UPLOAD_FILE_ID, :RELATION_OBJECT, :RELATION_ID, :SH0RT_FILE_NAME, :LONG_FILE_NAME, :DOCUMENT_TYPE, :DESCRIPTION, :CREATE_DATE, :CREATE_USER_ID)"; OracleParameter[] oraParameters = new OracleParameter[9]; oraParameters[0] = new OracleParameter(":UPLOAD_FILE_ID", uploadFileId); oraParameters[1] = new OracleParameter(":RELATION_OBJECT", fileInf.RelationObject); oraParameters[2] = new OracleParameter(":RELATION_ID", fileInf.RelationId); oraParameters[3] = new OracleParameter(":SH0RT_FILE_NAME", fileInf.Name); oraParameters[4] = new OracleParameter(":LONG_FILE_NAME", fileInf.Name); oraParameters[5] = new OracleParameter(":DOCUMENT_TYPE", StaticsVariable.DOCUMENT_TYPE); oraParameters[6] = new OracleParameter(":DESCRIPTION", StaticsVariable.DESCRIPTION); oraParameters[7] = new OracleParameter(":CREATE_DATE", DateTime.Now); oraParameters[8] = new OracleParameter(":CREATE_USER_ID", AppSettingHelper.Default.userid); if (Exec(commandText, oraParameters)) { OracleParameter[] selParameters = new OracleParameter[2]; selParameters[0] = new OracleParameter(":UPLOAD_FILE_ID", uploadFileId); selParameters[1] = new OracleParameter(":SH0RT_FILE_NAME", fileInf.Name); objIds = ExecuteScalar("SELECT UPLOAD_FILE_ID FROM GNLD_UPLOAD_FILE WHERE UPLOAD_FILE_ID = :UPLOAD_FILE_ID OR SH0RT_FILE_NAME = :SH0RT_FILE_NAME", selParameters); if (objIds != null && object.ReferenceEquals(objIds, DBNull.Value) == false) { return(Convert.ToInt32(objIds)); } return(uploadFileId); } else { return(-1); } } catch (Exception exception) { Logger.E(string.Concat("Yeni kayıt eklenemedi! Message:" + exception.Message, ",StackTrace:", exception.StackTrace)); return(-2); } }
private void Kaydet(object paramobj) { try { Thread.Sleep(1000); Thread.Sleep(1000); FileInfo inf = new FileInfo(paramobj.ToString()); lock (lockObject) { using (UnitOfWork wrk = new UnitOfWork()) { PdfFileInfo pdf = new PdfFileInfo(wrk); pdf.Name = inf.Name; pdf.FullName = inf.FullName; pdf.Extension = inf.Extension; pdf.CreationTime = inf.CreationTime; try { pdf.Length = inf.Length; } catch { } //pdf.FileType = PDFExpression.DosyaTuru(Path.GetFileNameWithoutExtension(inf.FullName)); pdf.FileType = PdfFileType.Bilinmiyor; pdf.ChangeType = WatcherChangeTypes.Created; pdf.Save(); Utility.WriteTrace(pdf.ToString()); wrk.CommitChanges(); } } if (!StaticsVariable.APPVISIBLE) { this.notifyIconApp.ShowBalloonTip(1000, "UyumSoft", "Yeni dosya algılandı." + inf.Name, ToolTipIcon.Info); } else { Utility.WriteTrace("Yeni dosya algılandı." + inf.Name); } } catch (Exception exc) { Utility.WriteTrace(exc.Message); Utility.WriteTrace(exc.StackTrace); } }
private void btnDel_Click(object sender, EventArgs e) { try { if (listView.SelectedIndices.Count > 0) { int oid = Convert.ToInt32(listView.Items[listView.SelectedIndices[0]].Text); if (Utility.Sor(oid + " nolu kayıt silinecek kabul ediyor musunuz?")) { PdfFileInfo file = XpoDefault.Session.GetObjectByKey <PdfFileInfo>(oid); if (file != null) { file.Delete(); } Dosyalar(); } } } catch (Exception exc) { Utility.Hata(exc); } }