public AffidavitHistory UpdateAffidavitHistory(AffidavitHistory model) { try { var affidavit = context.Affidavit.Where(x => x.AffidavitID.Equals(model.AffidavitId)).FirstOrDefault(); var status = context.AffidavitStatus.Where(x => x.AffidavitStatusId == model.AffidavitStatusId).FirstOrDefault(); model.StatusValue = status.Status; affidavit.Status = status.AffidavitStatusId; context.AffidavitHistory.Add(model); context.SaveChanges(); } catch (Exception ex) { Log.Error(ex); model = null; } return(model); }
public AffidavitHistory UpdateAffidavitHistory(long affidavitNo, int statusValue, int inspectorId) { //Affidavit affidavit = affidavitLogic.GetAffidavitDetails_SWP(affidavitNo); AffidavitHistory history = new AffidavitHistory(); //if (affidavit.AffidavitStatus.AffidavitStatusId != statusValue) //{ try { history.AffidavitId = affidavitNo; history.AffidavitStatusId = statusValue; history.InspectorId = inspectorId; history.CreatedDate = DateTime.Now; history = affidavitLogic.UpdateAffidavitHistory(history); } catch (Exception) { history = null; } // } return(history); }
public bool AddAffidavitFinalInspection(AffidavitFinalInspection model, int type) { bool result = false; try { var existingRecord = context.AffidavitFinalInspection.Where(x => x.AffidavitID.Equals(model.AffidavitID)).FirstOrDefault(); if (existingRecord == null) { model.InspectionDate = DateTime.Now; AffidavitHistory history = new AffidavitHistory(); var affidavit = context.Affidavit.Where(x => x.AffidavitID.Equals(model.AffidavitID)).FirstOrDefault(); var status = context.AffidavitStatus.Where(x => x.AffidavitStatusId == type).FirstOrDefault(); history.StatusValue = status.Status; affidavit.Status = status.AffidavitStatusId; history.AffidavitId = model.AffidavitID; history.AffidavitStatusId = type; history.CreatedDate = DateTime.Now; if (type == 8) { history.Comments = model.OtherRepairsNotAcceptable; history.InspectorId = model.FinalFailInspectorId; model.FinalFailDate = DateTime.Now; } else if (type == 12) { history.Comments = model.OtherRepairsAreCompleteAndSatisfactory; history.InspectorId = model.FinalPassInspectorId; model.RepairsComplete = true; model.CompletionDate = DateTime.Now; } context.AffidavitFinalInspection.Add(model); context.AffidavitHistory.Add(history); context.SaveChanges(); } else { var existingRecordHistory = context.AffidavitHistory.Where(x => x.AffidavitStatusId == type && x.AffidavitId == existingRecord.AffidavitID).FirstOrDefault(); if (existingRecordHistory != null) { var history = context.AffidavitHistory.Where(x => x.AffidavitId.Equals(model.AffidavitID) && x.AffidavitStatusId.Equals(type)).FirstOrDefault(); if (type == 8) { history.Comments = model.OtherRepairsNotAcceptable; history.InspectorId = model.FinalFailInspectorId; model.FinalFailDate = DateTime.Now; } else if (type == 12) { history.Comments = model.OtherRepairsAreCompleteAndSatisfactory; history.InspectorId = model.FinalPassInspectorId; existingRecord.RepairsComplete = true; existingRecord.CompletionDate = DateTime.Now; } history.CreatedDate = DateTime.Now; } else { AffidavitHistory history = new AffidavitHistory(); var affidavit = context.Affidavit.Where(x => x.AffidavitID.Equals(model.AffidavitID)).FirstOrDefault(); var status = context.AffidavitStatus.Where(x => x.AffidavitStatusId == type).FirstOrDefault(); history.StatusValue = status.Status; affidavit.Status = status.AffidavitStatusId; history.AffidavitId = model.AffidavitID; history.AffidavitStatusId = type; history.CreatedDate = DateTime.Now; if (type == 8) { history.Comments = model.OtherRepairsNotAcceptable; history.InspectorId = model.FinalFailInspectorId; model.FinalFailDate = DateTime.Now; } else if (type == 12) { history.Comments = model.OtherRepairsAreCompleteAndSatisfactory; history.InspectorId = model.FinalPassInspectorId; existingRecord.RepairsComplete = true; existingRecord.CompletionDate = DateTime.Now; } //history.InspectorId = model.InspectorID; context.AffidavitHistory.Add(history); } existingRecord.Sidewalk = model.Sidewalk; existingRecord.Driveway = model.Driveway; existingRecord.Curb = model.Curb; existingRecord.ContractorRepaired = model.ContractorRepaired; existingRecord.ContractorRepairedNotCitySpec = model.ContractorRepairedNotCitySpec; existingRecord.OwnerRepaired = model.OwnerRepaired; existingRecord.OwnerRepairedNotCitySpec = model.OwnerRepairedNotCitySpec; existingRecord.RemoveFormsToGrade = model.RemoveFormsToGrade; existingRecord.MoreBackfill = model.MoreBackfill; existingRecord.IncompleteRepairs = model.IncompleteRepairs; existingRecord.MoreGrinding = model.MoreGrinding; existingRecord.RemoveMarkedAreas = model.RemoveMarkedAreas; existingRecord.AsphaltWork = model.AsphaltWork; existingRecord.Graffiti = model.Graffiti; existingRecord.NoRightWayPermit = model.NoRightWayPermit; existingRecord.OtherRepairsNotAcceptable = model.OtherRepairsNotAcceptable; existingRecord.OtherRepairsAreCompleteAndSatisfactory = model.OtherRepairsAreCompleteAndSatisfactory; context.SaveChanges(); } result = true; } catch (Exception ex) { result = false;; } return(result); }
public bool AddAffidavitFormInspection(AffidavitFormInspection model, int type) { bool result = false; try { var existingRecord = context.AffidavitFormInspection.Where(x => x.AffidavitId.Equals(model.AffidavitId)).FirstOrDefault(); if (existingRecord == null) { model.InspectionDate = DateTime.Now; AffidavitHistory history = new AffidavitHistory(); var affidavit = context.Affidavit.Where(x => x.AffidavitID.Equals(model.AffidavitId)).FirstOrDefault(); var status = context.AffidavitStatus.Where(x => x.AffidavitStatusId == type).FirstOrDefault(); history.StatusValue = status.Status; affidavit.Status = status.AffidavitStatusId; history.AffidavitId = model.AffidavitId; history.AffidavitStatusId = type; history.CreatedDate = DateTime.Now; if (type == 5) { history.Comments = model.OtherDoNotPour; history.InspectorId = model.FormFailInspectorId; model.FormFailDate = DateTime.Now; } else if (type == 6) { history.Comments = model.OtherGrantedToPour; history.InspectorId = model.FormPassInspectorId; model.PermissionGranted = true; model.CompletionDate = DateTime.Now; } //model.AffidavitHistory.Add(history); context.AffidavitFormInspection.Add(model); context.AffidavitHistory.Add(history); context.SaveChanges(); } else { //var existingRecordHistory = existingRecord.AffidavitHistory.Where(x => x.AffidavitStatusId == type).FirstOrDefault(); var existingRecordHistory = context.AffidavitHistory.Where(x => x.AffidavitStatusId == type && x.AffidavitId == existingRecord.AffidavitId).FirstOrDefault(); if (existingRecordHistory != null) { var history = context.AffidavitHistory.Where(x => x.AffidavitId.Equals(model.AffidavitId) && x.AffidavitStatusId.Equals(type)).FirstOrDefault(); if (type == 5) { history.Comments = model.OtherDoNotPour; history.InspectorId = model.FormFailInspectorId; model.FormFailDate = DateTime.Now; } else if (type == 6) { history.Comments = model.OtherGrantedToPour; history.InspectorId = model.FormPassInspectorId; existingRecord.PermissionGranted = true; existingRecord.CompletionDate = DateTime.Now; } history.CreatedDate = DateTime.Now; } else { AffidavitHistory history = new AffidavitHistory(); var affidavit = context.Affidavit.Where(x => x.AffidavitID.Equals(model.AffidavitId)).FirstOrDefault(); var status = context.AffidavitStatus.Where(x => x.AffidavitStatusId == type).FirstOrDefault(); history.StatusValue = status.Status; affidavit.Status = status.AffidavitStatusId; history.AffidavitId = model.AffidavitId; history.AffidavitStatusId = type; history.CreatedDate = DateTime.Now; if (type == 5) { history.Comments = model.OtherDoNotPour; history.InspectorId = model.FormFailInspectorId; model.FormFailDate = DateTime.Now; } else if (type == 6) { history.Comments = model.OtherGrantedToPour; history.InspectorId = model.FormPassInspectorId; existingRecord.PermissionGranted = true; existingRecord.CompletionDate = DateTime.Now; } context.AffidavitHistory.Add(history); } existingRecord.Sidewalk = model.Sidewalk; existingRecord.Driveway = model.Driveway; existingRecord.Curb = model.Curb; existingRecord.NotReady = model.NotReady; existingRecord.InsufficientBarricades = model.InsufficientBarricades; existingRecord.RemoveDebris = model.RemoveDebris; existingRecord.NotDeep = model.NotDeep; existingRecord.CurbHeight = model.CurbHeight; existingRecord.SawCutEdges = model.SawCutEdges; existingRecord.NoPermit = model.NoPermit; existingRecord.OtherDoNotPour = model.OtherDoNotPour; existingRecord.OtherGrantedToPour = model.OtherGrantedToPour; existingRecord.Partial = model.Partial; existingRecord.PartialDescription = model.PartialDescription; existingRecord.MatchJointPattern = model.MatchJointPattern; existingRecord.ToolDeepJoints = model.ToolDeepJoints; existingRecord.PlaceJoints = model.PlaceJoints; //existingRecord.PermissionGranted = model.PermissionGranted; context.SaveChanges(); } result = true; } catch (Exception ex) { result = false;; } return(result); }