public dynamic removeHomecellNotes(dynamic HomecellNotesName) //get string parameter { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //establish database connection db.Configuration.ProxyCreationEnabled = false; //configure proxy to eliminate overload of data try { string file = HomecellNotesName.FileName; //retrieve Homecell notes to remove based on selected Homecell notes Homecell_Notes HCNotes = db.Homecell_Notes.Where(z => z.HomecellNotes == file).FirstOrDefault(); db.Homecell_Notes.Remove(HCNotes); //Add to Audit trail entity Audit_Trail auditLog = new Audit_Trail(); auditLog.PersonID = HomecellNotesName.PersonID; auditLog.EventDescription = "Removed Homecell Notes with with ID: " + HCNotes.HCNID; auditLog.EventDateTime = DateTime.Now; db.Audit_Trail.Add(auditLog); db.SaveChanges(); } catch (Exception) { return(null); } return(getHomecellNotes()); }
public List <dynamic> HomecellNotesByID([FromBody] Homecell_Notes HomecellNotesID) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //establish database connection db.Configuration.ProxyCreationEnabled = false; // configure proxy to eliminate overload of memory if (HomecellNotesID.HCNID == 0) // if ID is zero all Homecell notes needs to be retrieved by calling the getHomecellNotes method { return(getHomecellNotes()); // return called method } //if condition and return not met return only the selected Homecell notes return(HCNotesInformation(db.Homecell_Notes.Where(z => z.HCNID == HomecellNotesID.HCNID).ToList())); // return called method with where clause }
public dynamic AddHomecellNotes(dynamic HomecellNotesName) //get string parameter { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //establish database connection db.Configuration.ProxyCreationEnabled = false; //configure proxy to eliminate overload of data dynamic returnMessage = new ExpandoObject(); string file = HomecellNotesName.FileName; //check if notes where already added Homecell_Notes checkNotes = db.Homecell_Notes.Where(z => z.HomecellNotes == file).FirstOrDefault(); Homecell_Notes newHomecellNotes = new Homecell_Notes(); //create object of type Homecell_Notes to add to the database if (checkNotes == null) //check to see if notes already exist in the databse { newHomecellNotes.UploadDate = DateTime.Today; newHomecellNotes.HomecellNotes = file; db.Homecell_Notes.Add(newHomecellNotes); db.SaveChanges(); //retrieve Homecell notes to remove based on selected Homecell notes Homecell_Notes HCNotes = db.Homecell_Notes.Where(z => z.HomecellNotes == file).FirstOrDefault(); //Add to Audit trail entity Audit_Trail auditLog = new Audit_Trail(); auditLog.PersonID = HomecellNotesName.PersonID; auditLog.EventDescription = "Added Homecell Notes with with ID: " + HCNotes.HCNID; auditLog.EventDateTime = DateTime.Now; db.Audit_Trail.Add(auditLog); db.SaveChanges(); returnMessage = "Successfull"; } else //if it exist an error message is returned. { returnMessage = "The file you are trying to upload, has already been uploaded. Please try again by uploading a different file."; } return(returnMessage); //return message to Angular }