public bool AddNoteToInspection(string inspectionUUID, string noteUUID, int noteType, string content, int orderNumber, string name, int userId, DateTime modifiedTime) { //find inspection id by uuid int inspectionId = context.Inspections.Where(i => i.UUID == inspectionUUID).Select(i => i.Id).FirstOrDefault(); //create Note CSInspectionDatabaseModel.Note note = new CSInspectionDatabaseModel.Note(); note.UUID = noteUUID; note.Type = noteType; note.Content = content; note.OrderNumber = orderNumber; note.CreatedBy = userId; note.ModifiedBy = userId; note.CreatedTime = modifiedTime; note.ModifiedTime = modifiedTime; note.UpdatedTime = DateTime.Now; note.Name = name; context.Notes.Add(note); context.SaveChanges(); int noteId = context.Notes.Where(n => n.UUID == noteUUID).Select(n => n.Id).FirstOrDefault(); //connect InspectionNote CSInspectionDatabaseModel.InspectionNote inspectionNote = new InspectionNote(); inspectionNote.InspectionId = inspectionId; inspectionNote.NoteId = noteId; context.InspectionNotes.Add(inspectionNote); context.SaveChanges(); bool isSuccess = context.InspectionNotes.Any(an => an.InspectionId == inspectionId && an.NoteId == noteId); return isSuccess; }
public bool AddNoteToQuestion(string inspectionUUID, string noteUUID, int questionId, int noteType, string content, string name, int orderNumber, int userId, DateTime modifiedTime) { //find inspection id by uuid int inspectionId = context.Inspections.Where(i => i.UUID == inspectionUUID).Select(i => i.Id).FirstOrDefault(); //finde answerId by InspectionId and questionId int answerId = context.Answers.Where(a => a.InspectionId == inspectionId && a.QuestionId == questionId).Select(a => a.Id).FirstOrDefault(); //create Answer with inspectionId and questionId is not exist if (answerId == 0) { //create answer CSInspectionDatabaseModel.Answer answer = new CSInspectionDatabaseModel.Answer(); answer.QuestionId = questionId; answer.AnsweredBy = userId; answer.InspectionId = inspectionId; answer.CreatedTime = modifiedTime; answer.ModifiedTime = modifiedTime; answer.UpdatedTime = DateTime.Now; context.Answers.Add(answer); context.SaveChanges(); answerId = context.Answers.Where(a => a.InspectionId == inspectionId && a.QuestionId == questionId).Select(a => a.Id).FirstOrDefault(); } //create Note CSInspectionDatabaseModel.Note note = new CSInspectionDatabaseModel.Note(); note.UUID = noteUUID; note.Type = noteType; note.Content = content; note.OrderNumber = orderNumber; note.CreatedBy = userId; note.ModifiedBy = userId; note.CreatedTime = modifiedTime; note.ModifiedTime = modifiedTime; note.UpdatedTime = DateTime.Now; note.Name = name; context.Notes.Add(note); context.SaveChanges(); int noteId = context.Notes.Where(n => n.UUID == noteUUID).Select(n => n.Id).FirstOrDefault(); //connect AnswerNote CSInspectionDatabaseModel.AnswerNote answerNote = new AnswerNote(); answerNote.AnswerId = answerId; answerNote.NoteId = noteId; context.AnswerNotes.Add(answerNote); context.SaveChanges(); bool isSuccess = context.AnswerNotes.Any(an => an.AnswerId == answerId && an.NoteId == noteId); return isSuccess; }