public bool AddAffidavitFinalInspection(AffidavitFinalInspection model, int type)
{
bool result = false;
try
{
result = formLogic.AddAffidavitFinalInspection(model, type);
}
catch (Exception)
{
result = false;;
}
return(result);
}
public AffidavitFinalInspection GetAffidavitFinalInspection(long affidavitNo, int type)
{
AffidavitFinalInspection result = new AffidavitFinalInspection();
try
{
result = formLogic.GetAffidavitFinalInspection(affidavitNo, type);
}
catch (Exception)
{
result = null;
}
return(result);
}
public AffidavitFinalInspection GetAffidavitFinalInspection(long affidavitNo, int type)
{
AffidavitFinalInspection result = new AffidavitFinalInspection();
try
{
result = context.AffidavitFinalInspection.Where(x => x.AffidavitID.Equals(affidavitNo)).FirstOrDefault();
}
catch (Exception ex)
{
result = null;
}
return(result);
}
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);
}
