/// <summary> /// Save Button - used to save a record. If the assignee is invalid it displays an error. /// The record the verified before getting saved. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Save_Click(object sender, EventArgs e) { try { using (Database objDB = getDatabase()) //create a database object { recNumber = RecNumVal.Text; //record number title = RecTitleVal.Text; //record title date = new TrimDateTime(DateCreatedVal.Text); //record date of creation locName = AssigneeVal.Text; //record assignee Record rec = new Record(objDB, recNumber); //record object rec.Title = title; rec.DateCreated = date; location = new Location(objDB, rec.Assignee.Name); //location object if (location.Name != locName) //checking if the assignee name has changed { try { Location loc = new Location(objDB, locName); rec.SetAssignee(loc); } //An exception is thrown if the location name is invalid catch (Exception k) { System.Diagnostics.Trace.WriteLine(k.Message); MessageBox.Show("The assingee is invalid or does not exist"); return; } } //Saving the record object if (rec.Verify(true)) { rec.Save(); MessageBox.Show("Record Saved"); } else //Error is displayed if record verification fails { MessageBox.Show(rec.ErrorMessage); } } } // Display any exception thrown in a msgbox catch (Exception k) { MessageBox.Show(k.Message); } }
private static long CreateNewRMRecord(string FileLoc, long cont, Database db) { long uri = 0; string newtitle = null; try { if (File.Exists(FileLoc)) { RecordType rt = null; // Console.WriteLine("Document location: " + FileLoc); string strExt = Path.GetExtension(FileLoc); switch (strExt) { //Documents case ".PDF": case ".pdf": case ".DOC": case ".doc": case ".XLS": case ".xls": case ".DOCX": case ".docx": case ".XLSX": case ".xlsx": case ".ppt": case ".PPT": case ".pptx": case ".PPTX": case ".DOTX": case ".dotx": case ".TXT": case ".txt": case ".CSV": case ".csv": case ".PUB": case ".pub": case ".HTML": case ".html": case ".HTM": case ".htm": case ".DWG": case ".dwg": case ".RTF": case ".rtf": case ".XLSM": case ".xlsm": case ".MP4": case ".mp4": case ".DOT": case ".dot": case ".VSD": case ".vsd": case ".ZIP": case ".zip": case ".PSD": case ".psd": case ".RDL": case ".rdl": case ".XML": case ".xml": case ".INDD": case ".MHT": //NS case ".MPP": //NS case ".CFM": //NS case ".XLTM": //NS case ".SHX": //NS case ".PPSX": //NS case ".CSS": //NS case ".XLTX": //NS case ".JS": //NS" case ".OTF": //NS case ".VST": //NS case ".WMV": //NS case ".WMZ": //NS case ".OFT": //NS case ".MOV": //NS case ".PPS": //NS case ".MDB": //NS case ".EPS": //NS case ".XPS": //NS case ".XLSB": //NS case ".MID": //NS case ".THMX": //NS case ".TMP": //NS case ".TTF": //NS case ".MXD": //NS case ".ICS": //NS case ".DOCM": //NS case ".BPMN": //NS case ".AI": //NS case ".AVI": //NS case ".DXF": //NS case ".INI": //NS case ".LOG": //NS case ".LST": //NS case ".ODT": //NS case ".PARTIAL": //NS case ".POT": //NS case ".POTX": //NS case ".VSDX": //NS case ".SKP": //NS case ".SHS": //NS case ".RPT": //NS case ".XLA": //NS rt = new RecordType(db, 2); break; //Images case ".JPG": case ".TIF": case ".jpg": case ".tif": case ".PNG": case ".png": case ".JPEG": case ".jpeg": case ".GIF": case ".gif": case ".BMP": case ".bmp": case ".MPEG": case ".TIFF": rt = new RecordType(db, 14); break; //Mail case ".EML": case ".eml": case ".msg": case ".MSG": rt = new RecordType(db, 3); newtitle = SetEmailTitle(FileLoc); break; } Record rcont = new Record(db, cont); Record r = new Record(rt); Location lo = new Location(db, 5503); if (newtitle != null) r.Title = newtitle; r.SetDocument(FileLoc); r.SetAssignee(lo); r.SetOwnerLocation(lo); r.Container = rcont; r.Save(); uri = r.Uri; Console.WriteLine("Migrated document from: " + FileLoc + " and saved as " + r.Number); db.LogExternalEvent("Document migrated from: " + FileLoc, BaseObjectTypes.Record, uri, true); } else { Console.WriteLine("Document location does not exist: " + FileLoc); db.LogExternalEvent("Document location does not exist: "+FileLoc, BaseObjectTypes.Record, Convert.ToInt64(cont), true); } } catch (Exception exp) { Console.WriteLine("Error: " + exp.Message.ToString()); db.LogExternalEvent("Error migrating: " + FileLoc+" Error: "+exp.Message.ToString(), BaseObjectTypes.Record, Convert.ToInt64(cont), true); } return uri; }
private static long CreateNewRMfolder(string str4, long classification, Database db) { long uri = 0; Classification objclas = new Classification(db, classification); long clasUri = objclas.Uri; RecordType rt = new RecordType(db, 1); Record r = new Record(rt); Classification c = new Classification(db, clasUri); Location lo = new Location(db, 5503); r.OwnerLocation = lo; r.SetAssignee(lo); r.Classification = c; r.Title = str4; r.Save(); uri = r.Uri; return uri; }
private static long CreateNewRMSubFolder(long conturi, string str5, Database db) { long uri = 0; Record rCont = new Record(db, conturi); RecordType rtsub = new RecordType(db, 5); Record rsub = new Record(rtsub); rsub.Title = str5; rsub.Container = rCont; rsub.SetAssignee(rCont.Assignee); rsub.Save(); uri = rsub.Uri; return uri; }
static void ProcessProperty(string Name) { TrimApplication.Initialize(); using (Database db = new Database()) { db.Id = "10"; //db.WorkgroupServerName = "https://SCDB98:9443"; db.Connect(); //Console.WriteLine("DB test: " + db.CurrentUser.Name); // JsonSerializer s = new JsonSerializer(); try { T1Property t1 = null; using (StreamReader sr = new StreamReader(Name)) { using (JsonTextReader reader = new JsonTextReader(sr)) { //T1Integration t1 = new T1Integration(); t1 = (T1Property)s.Deserialize(reader, typeof(T1Property)); } } if (t1 != null) { FieldDefinition fdPropertyAddress = new FieldDefinition(db, 502); if (t1.EddieUri == 0) { RecordType rt = new RecordType(db, 1); Record rec = new Record(rt); FieldDefinition fdPropertyNo = new FieldDefinition(db, 504); rec.Title = "Property folder - " + t1.PropertyNumber.ToString(); rec.SetFieldValue(fdPropertyNo, new UserFieldValue(t1.PropertyNumber)); rec.SetFieldValue(fdPropertyAddress, new UserFieldValue(t1.PropertyAddress)); Classification c = new Classification(db, 2616); rec.Classification = c; Location loc = new Location(db, 43); rec.SetAssignee(loc); //rec.assig rec.Save(); t1.EddieUri = rec.Uri; t1.EddieRecordUrl = rec.WebURL; Console.WriteLine("New property record created ok - number: " + rec.Number); } else { //RecordType rt = new RecordType(db, 2); Record rec = new Record(db, t1.EddieUri); //Record cont = new Record(db, t1.lEddieUri); //rec.Container = cont; //rec.Title = "Application - " + t1.ApplicationNo; //if (t1.propertyLoc != null) //{ // rec.SetDocument(t1.propertyLoc); //} rec.SetFieldValue(fdPropertyAddress, new UserFieldValue(t1.PropertyAddress)); rec.Save(); //t1.EddieUri = rec.Uri; t1.EddieRecordUrl = rec.WebURL; Console.WriteLine("Property record upgrades - number: " + rec.Number); } using (StreamWriter sw = new StreamWriter(pathout + "T1 property - "+t1.PropertyNumber.ToString()+".txt")) { using (JsonWriter writer = new JsonTextWriter(sw)) { s.Serialize(writer, t1); Console.WriteLine("Property file returned"); } }; FileInfo f = new FileInfo(Name); if (f.Exists) f.Delete(); } } catch (Exception exp) { Console.WriteLine("Error: " + exp.Message.ToString()); throw; } } }