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);
}
