public AffidavitFormInspection GetAffidavitFormInspection(long affidavitNo, int type)
{
AffidavitFormInspection result = new AffidavitFormInspection();
try
{
result = formLogic.GetAffidavitFormInspection(affidavitNo, type);
}
catch (Exception)
{
result = null;
}
return(result);
}
public bool AddAffidavitFormInspection(AffidavitFormInspection model, int type)
{
bool result = false;
try
{
result = formLogic.AddAffidavitFormInspection(model, type);
}
catch (Exception)
{
result = false;;
}
return(result);
}
public AffidavitFormInspection GetAffidavitFormInspection(long affidavitNo, int type)
{
AffidavitFormInspection result = new AffidavitFormInspection();
try
{
result = context.AffidavitFormInspection.Where(x => x.AffidavitId.Equals(affidavitNo)).FirstOrDefault();
//var history = context.AffidavitHistory.Where(x => x.AffidavitId.Equals(affidavitNo) && x.AffidavitStatusId.Equals(type)).FirstOrDefault();
//if (history == null)
//{
// result.Sidewalk = false;
// result.Driveway = false;
// result.Curb = false;
//}
}
catch (Exception ex)
{
result = null;
}
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);
}
