private Response EditQuestionNote(Inspection inspection, List<Question> questions) { Response response = new Response(); if (inspection.ModifiedTime == null) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection modification time data."; isInvalidData = true; } if (String.IsNullOrEmpty(inspection.UUID)) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection UUID"; isInvalidData = true; } if(!isInvalidData) { foreach (Question question in questions) { if (question.ModifiedTime == null) { response.Result = QueryResult.Fail; response.Message = "Invalid question modification time data."; isInvalidData = true; break; } if (question.Id == 0) { response.Result = QueryResult.Fail; response.Message = "Invalid question id"; isInvalidData = true; } if (isInvalidData) { break; } foreach (Note note in question.EditedNotes) { if (isInvalidData) { break; } if (String.IsNullOrEmpty(note.UUID)) { response.Result = QueryResult.Fail; response.Message = "Invalid note UUID"; isInvalidData = true; } if (note.OrderNumber == 0) { response.Result = QueryResult.Fail; response.Message = "Invalid note order number"; isInvalidData = true; } bool result = dal.ModifyNote(note.UUID, (int)note.Type, note.Content, note.Name, userId, question.ModifiedTime, note.OrderNumber); switch (result) { case true: response.Result = QueryResult.Success; break; case false: response.Result = QueryResult.Fail; response.Message = "Cannot edit note."; isInvalidData = true; break; } } if (response.Result != QueryResult.Fail) { response = EditQuestionModificationTime(inspection, question); if (response.Result == QueryResult.Fail) { //TODO rollback } } } } return response; }
private Response EditQuestion(Inspection inspection, List<Question> questions) { Response response = new Response(); response.Result = QueryResult.Fail; if (inspection.ModifiedTime == null) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection modification time data."; isInvalidData = true; } if (String.IsNullOrEmpty(inspection.UUID)) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection UUID"; isInvalidData = true; } if(!isInvalidData) { foreach (Question question in questions) { if (question.ModifiedTime == null) { response.Result = QueryResult.Fail; response.Message = "Invalid question modification time data."; isInvalidData = true; break; } if (question.Id == 0) { response.Result = QueryResult.Fail; response.Message = "Invalid question id"; isInvalidData = true; } if (isInvalidData == true) { break; } bool result = dal.SetQuestionPositiveNegativePercent(inspection.UUID, question.Id, question.PositivePercent, question.NegativePercent, userId, question.ModifiedTime); switch (result) { case true: response = EditQuestionModificationTime(inspection, question); if(response.Result == QueryResult.Fail) { //TODO rollback } break; case false: response.Result = QueryResult.Fail; response.Message = "Cannot edit question safeness."; isInvalidData = true; break; } } } return response; }
private Response EditQuestionModificationTime(Inspection inspection, Question question) { Response response = new Response(); bool result = dal.SetQuestionModificationTime(inspection.UUID, question.Id, question.ModifiedTime, userId); switch (result) { case true: response = EditInspectionModificationTime(inspection); if(response.Result == QueryResult.Fail) { //TODO rollback } break; case false: response.Result = QueryResult.Fail; response.Message = "Cannot edit question modification time."; isInvalidData = true; break; } return response; }
private Response EditInspection(Inspection inspection) { Response response = new Response(); response.Result = QueryResult.Fail; bool result = false; if (inspection.ModifiedTime == null) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection modification time data."; isInvalidData = true; } if (String.IsNullOrEmpty(inspection.UUID)) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection UUID"; isInvalidData = true; } #region EditSafeness if (isInvalidData != true) { result = dal.SetInspectionPositiveNegativePercent(inspection.UUID, inspection.PositivePercent, inspection.NegativePercent); switch (result) { case true: response.Result = QueryResult.Success; break; case false: response.Result = QueryResult.Fail; response.Message = "Cannot edit inspection safeness."; isInvalidData = true; //TODO rollback break; } } #endregion #region EditName if (isInvalidData != true && String.IsNullOrEmpty(inspection.Name) != true) { result = dal.SetInspectionName(inspection.UUID, inspection.Name); switch (result) { case true: response.Result = QueryResult.Success; break; case false: response.Result = QueryResult.Fail; response.Message = "Cannot edit inspection name."; isInvalidData = true; //TODO rollback break; } } #endregion if(response.Result != QueryResult.Fail) { response = EditInspectionModificationTime(inspection); if (response.Result == QueryResult.Fail) { //TODO rollback } } return response; }
private Response EditInspectionModificationTime(Inspection inspection) { Response response = new Response(); bool result = false; result = dal.SetInspectionModificationTime(inspection.UUID, userId, inspection.ModifiedTime); switch (result) { case true: response.Result = QueryResult.Success; break; case false: response.Result = QueryResult.Fail; response.Message = "Cannot edit inspection modification time."; isInvalidData = true; break; } return response; }
private Response DeleteInspectionNote(Inspection inspection, List<Note> notes) { Response response = new Response(); if (inspection.ModifiedTime == null) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection modification time data."; isInvalidData = true; } if (String.IsNullOrEmpty(inspection.UUID)) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection UUID"; isInvalidData = true; } if (!isInvalidData) { foreach (Note note in notes) { if (String.IsNullOrEmpty(note.UUID)) { response.Result = QueryResult.Fail; response.Message = "Invalid note UUID"; isInvalidData = true; } if (isInvalidData) { break; } bool result = dal.DeleteNote(0, note.UUID); switch (result) { case true: response.Result = QueryResult.Success; break; case false: response.Result = QueryResult.Fail; response.Message = "Cannot delete note."; isInvalidData = true; break; } } if (response.Result != QueryResult.Fail) { response = EditInspectionModificationTime(inspection); if (response.Result == QueryResult.Fail) { //TODO rollback } } } return response; }
private Response AddNoteToQuestion(Inspection inspection, List<Question> questions) { Response response = new Response(); response.Result = QueryResult.Fail; bool result = false; if (inspection.ModifiedTime == null) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection modification time data."; isInvalidData = true; } if (String.IsNullOrEmpty(inspection.UUID)) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection UUID"; isInvalidData = true; } if (!isInvalidData) { foreach (Question question in questions) { if (question.ModifiedTime == null) { response.Result = QueryResult.Fail; response.Message = "Invalid question modification time data."; isInvalidData = true; break; } if (question.Id == 0) { response.Result = QueryResult.Fail; response.Message = "Invalid question id"; isInvalidData = true; } if (isInvalidData == true) { break; } foreach (Note note in question.AddedNotes) { if (isInvalidData == true) { break; } if (String.IsNullOrEmpty(note.UUID) != true && Enum.IsDefined(typeof(NoteType), note.Type) != false && String.IsNullOrEmpty(note.Content) != true && note.OrderNumber != 0) { result = dal.AddNoteToQuestion(inspection.UUID, note.UUID, question.Id, (int)note.Type, note.Content, note.Name, note.OrderNumber, userId, question.ModifiedTime); if (result) { response.Result = QueryResult.Success; result = false; } else { response.Result = QueryResult.Fail; response.Message = "Cannot create note."; isInvalidData = true; } } else { response.Result = QueryResult.Fail; response.Message = "Invalid note data"; isInvalidData = true; } if(response.Result != QueryResult.Fail) { response = EditQuestionModificationTime(inspection, question); if (response.Result == QueryResult.Fail) { break; //TODO rollback } } } } } return response; }
private Response AddNewInspection(Inspection inspection) { Response response = new Response(); response.Result = QueryResult.Fail; bool result = false; if (Enum.IsDefined(typeof(InspectionType), inspection.Type) == false || String.IsNullOrEmpty(inspection.UUID) == true || String.IsNullOrEmpty(inspection.Name) == true || String.IsNullOrEmpty(inspection.LocationWhenCreated) == true || inspection.CreatedTime == null || inspection.ModifiedTime == null) { response.Result = QueryResult.Fail; response.Message = "Invalid inspection data"; isInvalidData = true; } if(!isInvalidData) { result = dal.CreateInspection(inspection.UUID, (int)inspection.Type, inspection.Name, userId, inspection.PositivePercent, inspection.NegativePercent, inspection.LocationWhenCreated, inspection.CreatedTime, inspection.ModifiedTime); if (result) { response.Result = QueryResult.Success; } else { response.Result = QueryResult.Fail; response.Message = "Cannot create inspection."; isInvalidData = true; } } return response; }
public static void Initialize() { if (!isInitialized) { #region Inspection isInitialized = true; Inspection inspection_1 = new Inspection { CreatedTime = DateTime.Now, Type = InspectionType.ProjectInspection, IsSafe = IsSafe.NotComplited, LocationWhenCreated = "some location", ModifiedTime = DateTime.Now, Name = "Inspection 1 for ProjectInspection", Id = 1 }; Inspection inspection_2 = new Inspection { CreatedTime = DateTime.Now, Type = InspectionType.SubcontractorInspection, IsSafe = IsSafe.NotComplited, LocationWhenCreated = "some location", ModifiedTime = DateTime.Now, Name = "Inspection 1 for SubcontractorInspection", Id = 2 }; inspections.Add(inspection_1); inspections.Add(inspection_2); #endregion #region Category categories.Add(new Category { Id = 1, Name = "Administration" }); categories.Add(new Category { Id = 2, Name = "Asbestos" }); categories.Add(new Category { Id = 3, Name = "Confined Space" }); categories.Add(new Category { Id = 4, Name = "Control of Hazardous Energy" }); categories.Add(new Category { Id = 5, Name = "Demolition" }); categories.Add(new Category { Id = 6, Name = "Electrical Safety" }); categories.Add(new Category { Id = 7, Name = "Environmental" }); #endregion #region Note List<string> noteContents = new List<string>(); noteContents.Add("question note_1"); noteContents.Add("question note_2"); noteContents.Add("question note_3"); noteContents.Add("question note_4"); noteContents.Add("inspection note_1"); noteContents.Add("inspection note_2"); noteContents.Add("ToDelete"); int count = 1; foreach (string content in noteContents) { Note note = new Note { Id = count, Content = content, Type = NoteType.Text }; notes.Add(note); count++; } questionNote.Add(1, 1); questionNote.Add(2, 1); questionNote.Add(3, 2); questionNote.Add(4, 3); inspectionNote.Add(5, 1); inspectionNote.Add(6, 1); #endregion #region Question List<string> questionNames = new List<string>(); questionNames.Add("Accountability Plan Utilized"); questionNames.Add("Address Displayed On Perimeter"); questionNames.Add("Adequate 1st Aid Kits"); questionNames.Add("Adequate Eyewash Stations"); questionNames.Add("Annual Program Evaluation"); questionNames.Add("Competent Persons List"); questionNames.Add("Coord With Local FD"); questionNames.Add("CSAP Enrollment Complete"); int counter = 1; foreach (string name in questionNames) { Question question = new Question { Id = count, CreatedTime = DateTime.Now, IsSafe = IsSafe.NotComplited, ModifiedTime = DateTime.Now, Text = name, NotesCounter = questionNote.Where(n => n.Value == counter).Count() }; questions.Add(question); counter++; } #endregion } }
public ComplexObjects.Inspection GetInspection(string inspectionUUID) { CSInspectionDatabaseModel.Inspection inspectionFromDBModel = context.Inspections.Where(i => i.UUID == inspectionUUID).Select(i => i).FirstOrDefault(); ComplexObjects.Inspection inspection = new ComplexObjects.Inspection(); inspection.UUID = inspectionFromDBModel.UUID; inspection.Name = inspectionFromDBModel.Name; inspection.Type = (InspectionType)inspectionFromDBModel.Type; inspection.PositivePercent = inspectionFromDBModel.PositivePercent; inspection.NegativePercent = inspectionFromDBModel.NegativePercent; inspection.CreatedTime = inspectionFromDBModel.CreatedTime; inspection.ModifiedTime = inspectionFromDBModel.ModifiedTime; inspection.LocationWhenCreated = inspectionFromDBModel.LocationWhenCreated; return inspection; }