public void FieldSave(OBK_CertificateReference oldModel, OBK_CertificateReference newModel, Guid userId)
{
if ((newModel.Number == null && oldModel.Number != null) || (newModel.Number != null && !newModel.Number.Equals(oldModel.Number)))
{
LogChange(nameof(newModel.Number), newModel.Number.ToString(), userId,
newModel.Id, propertyNameRuList.First(x => x.Key == nameof(newModel.Number)).Value);
}
if ((newModel.CertificateNumber == null && oldModel.CertificateNumber != null) ||
(newModel.CertificateNumber != null && !newModel.CertificateNumber.Equals(oldModel.CertificateNumber)))
{
LogChange(nameof(newModel.CertificateNumber), newModel.CertificateNumber.ToString(), userId,
newModel.Id, propertyNameRuList.First(x => x.Key == nameof(newModel.CertificateNumber)).Value);
}
if ((newModel.StartDate == null && oldModel.StartDate != null) ||
(newModel.StartDate != null && !newModel.StartDate.Equals(oldModel.StartDate)))
{
LogChange(nameof(newModel.StartDate), newModel.StartDate.ToString(), userId,
newModel.Id, propertyNameRuList.First(x => x.Key == nameof(newModel.StartDate)).Value);
}
if ((newModel.EndDate == null && oldModel.EndDate != null) ||
(newModel.EndDate != null && !newModel.EndDate.Equals(oldModel.EndDate)))
{
LogChange(nameof(newModel.EndDate), newModel.EndDate.ToString(), userId,
newModel.Id, propertyNameRuList.First(x => x.Key == nameof(newModel.EndDate)).Value);
}
if ((newModel.CertificateOrganization == null && oldModel.CertificateOrganization != null) ||
(newModel.CertificateOrganization != null && !newModel.CertificateOrganization.Equals(oldModel.CertificateOrganization)))
{
LogChange(nameof(newModel.CertificateOrganization), newModel.CertificateOrganization.ToString(), userId,
newModel.Id, propertyNameRuList.First(x => x.Key == nameof(newModel.CertificateOrganization)).Value);
}
if (!newModel.CertificateTypeId.Equals(oldModel.CertificateTypeId))
{
LogChange(nameof(newModel.CertificateTypeId), newModel.CertificateTypeId.ToString(), userId,
newModel.Id, propertyNameRuList.First(x => x.Key == nameof(newModel.CertificateTypeId)).Value);
}
if ((newModel.LastInspection == null && oldModel.LastInspection != null) ||
(newModel.LastInspection != null && !newModel.LastInspection.Equals(oldModel.LastInspection)))
{
LogChange(nameof(newModel.LastInspection), newModel.LastInspection.ToString(), userId,
newModel.Id, propertyNameRuList.First(x => x.Key == nameof(newModel.LastInspection)).Value);
}
if ((newModel.CertificateCountryId == null && oldModel.CertificateCountryId != null) ||
(newModel.CertificateCountryId != null && !newModel.CertificateCountryId.Equals(oldModel.CertificateCountryId)))
{
LogChange(nameof(newModel.CertificateCountryId), newModel.CertificateCountryId.ToString(), userId,
newModel.Id, propertyNameRuList.First(x => x.Key == nameof(newModel.CertificateCountryId)).Value);
}
if ((newModel.CertificateValidityTypeId == null && oldModel.CertificateValidityTypeId != null) ||
(newModel.CertificateValidityTypeId != null && !newModel.CertificateValidityTypeId.Equals(oldModel.CertificateValidityTypeId)))
{
LogChange(nameof(newModel.CertificateValidityTypeId), newModel.CertificateValidityTypeId.ToString(), userId,
newModel.Id, propertyNameRuList.First(x => x.Key == nameof(newModel.CertificateValidityTypeId)).Value);
}
}
public void UpdateCertificates()
{
var list = AppContext.OBK_CertificateReference.Include(o => o.OBK_CertificateValidityType).ToList();
foreach (var obj in list)
{
if (obj.EndDate < DateTime.Now && !"Recalled".Equals(obj.OBK_CertificateValidityType.Code))
{
OBK_CertificateReference d = AppContext.OBK_CertificateReference.First(o => o.Id == obj.Id);
d.OBK_CertificateValidityType = AppContext.OBK_CertificateValidityType.First(o => o.Code == "Passive");
AppContext.SaveChanges();
}
}
}
public ActionResult DicDestroy([DataSourceRequest] DataSourceRequest request, OBKCertificateReferenceModel dictionary,
string type)
{
if (dictionary != null)
{
OBK_CertificateReference d = db.OBK_CertificateReference.First(o => o.Id == dictionary.Id);
//Document doc = db.Documents.First(o => o.Id == d.DocumentId);
db.OBK_CertificateReference.Remove(d);
db.SaveChanges();
}
return(Json(new[] { dictionary }.ToDataSourceResult(request, ModelState)));
}
public OBK_CertificateReference CopyObject(OBK_CertificateReference old)
{
return(new OBK_CertificateReference
{
Id = old.Id,
Number = old.Number,
CertificateNumber = old.CertificateNumber,
StartDate = old.StartDate,
EndDate = old.EndDate,
CertificateCountryId = old.CertificateCountryId,
CertificateOrganization = old.CertificateOrganization,
CertificateTypeId = old.CertificateTypeId,
CertificateValidityTypeId = old.CertificateValidityTypeId,
LastInspection = old.LastInspection
});
}
public ActionResult DocumentRead(Guid id)
{
OBK_CertificateReference reference = db.OBK_CertificateReference.Find(id);
OBKCertificateFileModel fileModel = new OBKCertificateFileModel();
if (reference != null && reference.AttachPath != null)
{
fileModel.AttachPath = reference.AttachPath;
fileModel.AttachFiles = UploadHelper.GetFilesInfo(fileModel.AttachPath.ToString(), false);
}
else
{
fileModel.AttachPath = FileHelper.GetObjectPathRoot();
fileModel.AttachFiles = UploadHelper.GetFilesInfo(fileModel.AttachPath.ToString(), false);
}
return(Content(JsonConvert.SerializeObject(fileModel, Formatting.Indented, new JsonSerializerSettings()
{
DateFormatString = "dd.MM.yyyy HH:mm"
})));
}
public ActionResult Recall([DataSourceRequest] DataSourceRequest request, Guid?Id)
{
OBK_CertificateReference obj = db.OBK_CertificateReference.FirstOrDefault(o => o.Id == Id);
var oldCopy = fieldSaver.CopyObject(obj);
if (obj != null)
{
obj.OBK_CertificateValidityType = db.OBK_CertificateValidityType.First(o => o.Code == "Recalled");
db.SaveChanges();
fieldSaver.FieldSave(oldCopy, obj, UserHelper.GetCurrentEmployee().Id);
return(Json(new
{
success = true
}));
}
return(Json(new
{
success = false
}));
}
public ActionResult DicCreate([DataSourceRequest] DataSourceRequest request, OBKCertificateReferenceModel dictionary)
{
if (dictionary != null && ModelState.IsValid)
{
OBK_CertificateReference d = new OBK_CertificateReference()
{
Id = (Guid)dictionary.Id,
Number = dictionary.Number,
CertificateNumber = dictionary.CertificateNumber,
StartDate = dictionary.StartDate,
EndDate = dictionary.EndDate,
CertificateCountryId = dictionary.CertificateCountryId,
CertificateOrganization = dictionary.CertificateOrganization,
CertificateProducer = dictionary.CertificateProducer,
CertificateTypeId = dictionary.CertificateTypeId,
LastInspection = dictionary.LastInspection,
AttachPath = dictionary.AttachPath,
CreateDate = DateTime.Now,
ExpertOrganization = UserHelper.GetCurrentEmployee().OrganizationId
};
if (dictionary.EndDate >= DateTime.Now)
{
OBK_CertificateValidityType t = db.OBK_CertificateValidityType.First(o => o.Code == "active");
d.OBK_CertificateValidityType = t;
}
else
{
OBK_CertificateValidityType t = db.OBK_CertificateValidityType.First(o => o.Code == "passive");
d.OBK_CertificateValidityType = t;
}
db.OBK_CertificateReference.Add(d);
db.SaveChanges();
fieldSaver.FieldSave(new OBK_CertificateReference(), d, UserHelper.GetCurrentEmployee().Id);
List <UploadInitialFile> physicalfiles = UploadHelper.GetFilesInfo(dictionary.AttachPath.ToString(), false);
List <FileLink> oldList = db.FileLinks.Where(o => o.DocumentId == dictionary.Id).ToList();
foreach (var file in physicalfiles)
{
if (!oldList.Any(o => o.FileName == file.name))
{
FileLink dbFile = new FileLink
{
Id = Guid.NewGuid(),
FileName = file.name,
CreateDate = DateTime.Now,
DocumentId = dictionary.Id,
OwnerId = UserHelper.GetCurrentEmployee().Id,
IsDeleted = false,
};
db.FileLinks.Add(dbFile);
fieldSaver.LogChange("FileLinks", dbFile.FileName, UserHelper.GetCurrentEmployee().Id,
dictionary.Id, "добавлен");
}
}
db.SaveChanges();
dictionary.Id = d.Id;
}
return(Json(new[] { dictionary }.ToDataSourceResult(request, ModelState)));
}
