public async Task <Guid> CreateNewChecklistDetailsElementAsync(ChecklistElementDetailModel checklistElementDetails) { try { var val = await _repository.CreateNewChecklistDetailsElementAsync(checklistElementDetails); return(val); } catch (OzoneException ex) { throw new OzoneException(ex.Message, ex.InnerException); } }
public async Task <bool> CreateNewChecklistElementDetailAsync(ChecklistElementDetailModel checklistElementDetail, Guid elementGuid) { try { var status = await _repository.CreateNewChecklistElementDetailAsync(checklistElementDetail, elementGuid); return(status); } catch (OzoneException ex) { throw new OzoneException(ex.Message, ex.InnerException); } }
public async Task <bool> UpdateChecklistElementDatailsAsync(ChecklistElementDetailModel elementDetailsModel) { try { var status = await _repository.UpdateChecklistElementDatailsAsync(elementDetailsModel); return(status); } catch (OzoneException ex) { throw new OzoneException(ex.Message, ex.InnerException); } }
private async Task <ChecklistElementDetailModel> GetElementDetailsByIdAsync(Guid elementDetailsGuid) { try { checklistElementDetailModel = await _db.ChecklistElementDetailsTable.FirstOrDefaultAsync(c => c.GuidId == elementDetailsGuid); return(checklistElementDetailModel); } catch (OzoneException ex) { throw new OzoneException("Error in Getting Element details from Database", ex); } }
// Checklist Element Details Section //public async Task CreateNewChecklistElementDetailAsync(ChecklistElementDetailModel checklistElementDetail, int elementId) //{ // checklistElementDetail.ElementId = elementId; // await _db.ChecklistElementDetailsTable.AddAsync(checklistElementDetail); // await _db.SaveChangesAsync(); //} public async Task <bool> CreateNewChecklistElementDetailAsync(ChecklistElementDetailModel checklistElementDetail, Guid elementGuid) { try { checklistElementDetail.GuidId = elementGuid; await _db.ChecklistElementDetailsTable.AddAsync(checklistElementDetail); var status = await _db.SaveChangesAsync() > 0; return(status); } catch (OzoneException ex) { throw new OzoneException("Error in Creating New Checklist Element Detail", ex); } }
public async Task <bool> UpdateChecklistElementDatailsAsync(ChecklistElementDetailModel elementDetailsModel) { try { await GetElementDetailsByIdAsync(elementDetailsModel.GuidId); var nextMaint = elementDetailsModel.EndEventDate; if (nextMaint != null) { nextMaint = nextMaint.Value.AddDays(7); } // checklistElementDetailModel.Status = elementDetailsModel.Status; //required checklistElementDetailModel.FaultType = elementDetailsModel.FaultType; //required checklistElementDetailModel.FaultOther = elementDetailsModel.FaultOther; checklistElementDetailModel.ActionType = elementDetailsModel.ActionType; checklistElementDetailModel.ActionOther = elementDetailsModel.ActionOther; //required checklistElementDetailModel.StartEventDate = elementDetailsModel.StartEventDate; checklistElementDetailModel.EndEventDate = elementDetailsModel.EndEventDate; //required checklistElementDetailModel.StartEventHour = elementDetailsModel.StartEventHour; checklistElementDetailModel.EndEventHour = elementDetailsModel.EndEventHour; checklistElementDetailModel.LastMINT = elementDetailsModel.EndEventDate; checklistElementDetailModel.NextMINT = nextMaint; //required checklistElementDetailModel.FaultDescription = elementDetailsModel.FaultDescription; checklistElementDetailModel.ResponseDescription = elementDetailsModel.ResponseDescription; checklistElementDetailModel.Note = " "; checklistElementDetailModel.EmployeesInvolved = elementDetailsModel.EmployeesInvolved; //required checklistElementDetailModel.PublicVisible = elementDetailsModel.PublicVisible; checklistElementDetailModel.FaultRank = "5"; checklistElementDetailModel.FinalStatus = elementDetailsModel.FinalStatus; checklistElementDetailModel.ElementId = elementDetailsModel.ElementId; return(await _db.SaveChangesAsync() > 0); } catch (OzoneException ex) { throw new OzoneException("Error in Updating data in Database", ex); } }
//public async Task<ChecklistElementDetailModel> GetSingleElementDetailsByIdAsync(int elementId) //{ // // var maxId = _db.ChecklistElementDetailsTable.Where(c => c.ElementId == elementId).Max(i => i.Id); // checklistElementDetailModel = await _db.ChecklistElementDetailsTable.FirstOrDefaultAsync(c => c.FinalStatus == false); // if (checklistElementDetailModel == null) // { // checklistElementDetailModel = await _db.ChecklistElementDetailsTable.OrderByDescending(c => c.Id).FirstOrDefaultAsync(); // } // return (checklistElementDetailModel); //} public async Task <ChecklistElementDetailModel> GetSingleElementDetailsAsync() { try { checklistElementDetailModel = await _db.ChecklistElementDetailsTable.FirstOrDefaultAsync(c => c.FinalStatus == false); if (checklistElementDetailModel == null) { checklistElementDetailModel = await _db.ChecklistElementDetailsTable.OrderByDescending(c => c.GuidId).FirstOrDefaultAsync(); } return(checklistElementDetailModel); } catch (OzoneException ex) { throw new OzoneException("Error in Getting Element Details from Database", ex); } }
public async Task <Guid> CreateNewChecklistDetailsElementAsync(ChecklistElementDetailModel checklistElementDetails) { try { Guid guid = Guid.NewGuid(); checklistElementDetails.GuidId = guid; await _db.ChecklistElementDetailsTable.AddAsync(checklistElementDetails); await _db.SaveChangesAsync(); var newElementDetailId = checklistElementDetails.GuidId; return(newElementDetailId); } catch (OzoneException ex) { throw new OzoneException("Error in Data Insertion into Database", ex); } }