public static void updateDoc(infoGathDocJSON doc) { InfoGathering newInfoDoc = convertToDBAO(doc); using (var curDB = new HelpDesk_DB()) { //Update old document to historic InfoGathering oldDoc = InfoGathList[doc.index]; var originalDoc = curDB.InfoGatherings.Find(oldDoc.id); originalDoc.Status_id = 4; //historic //Transfer persisting information to new document newInfoDoc.Original_id = oldDoc.id; curDB.SaveChanges(); } using (var curDB = new HelpDesk_DB()) { curDB.InfoGatherings.Add(newInfoDoc); curDB.SaveChanges(); //update info gath list for find and navigate references InfoGathList = curDB.InfoGatherings.Where(p => p.Status_id == 2).OrderBy(p => p.searchableAlias).ToList(); } logUsage(); }
/// <summary> /// Converts infoGathDocJSON to a DBAO InfoGathering object that is ready to be added to the DB. Does not touch ID, Original_ID /// </summary> /// <param name="JSON"></param> /// <returns></returns> public static InfoGathering convertToDBAO(infoGathDocJSON JSON) { InfoGathering infoGathDoc = new InfoGathering(); infoGathDoc.searchableAlias = JSON.searchableAlias; //Document Links if (JSON.infoGathLink != "") { infoGathDoc.infoGathLink_id = addDocumentLink(JSON.infoGathLink); } if (JSON.passwordHyperlink != "") { infoGathDoc.PasswordHyperlink_id = addDocumentLink(JSON.passwordHyperlink); } infoGathDoc.infoGathTitle = JSON.infoGathTitle; infoGathDoc.assignmentGroup = JSON.assignmentGroup; infoGathDoc.supportInfo = JSON.supportInfo; infoGathDoc.supportHours = JSON.supportHours; infoGathDoc.contactInfo = JSON.contactInfo; infoGathDoc.passwordAttributes = JSON.passwordAttributes; infoGathDoc.passwordTitle = JSON.passwordTitle; infoGathDoc.aliases = JSON.aliases; infoGathDoc.Status_id = 2; return(infoGathDoc); }
public static string convertSerializedJSON(InfoGathering doc) { infoGathDocJSON docJSON = new infoGathDocJSON(); docJSON.id = doc.id; docJSON.index = InfoGathList.IndexOf(doc); docJSON.searchableAlias = doc.searchableAlias; //Checks for 0 inputed into the databse because this isn't allowed to be null if (doc.infoGathLink_id != 0) { using (var curDB = new HelpDesk_DB()) { DocumentLink pdfDoc = curDB.DocumentLinks.SingleOrDefault(p => p.Id == doc.infoGathLink_id); if (pdfDoc != null) { docJSON.infoGathLink = pdfDoc.link; } else { docJSON.infoGathLink = ""; } } } docJSON.infoGathTitle = doc.infoGathTitle; docJSON.assignmentGroup = doc.assignmentGroup; docJSON.supportInfo = doc.supportInfo; docJSON.supportHours = doc.supportHours; docJSON.contactInfo = doc.contactInfo; doc.passwordAttributes = doc.passwordAttributes; doc.passwordTitle = doc.passwordTitle; if (doc.PasswordHyperlink_id != null) { using (var curDB = new HelpDesk_DB()) { DocumentLink pwDoc = curDB.DocumentLinks.SingleOrDefault(p => p.Id == doc.PasswordHyperlink_id); if (pwDoc != null) { docJSON.passwordHyperlink = pwDoc.link; } else { docJSON.passwordHyperlink = ""; } } } docJSON.aliases = doc.aliases; var json = new JavaScriptSerializer().Serialize(docJSON); return(json); }
public static void submit(infoGathDocJSON doc) { InfoGathering infoGathDoc = convertToDBAO(doc); addNewInfoGathering(infoGathDoc); }