public ActionResult LoadStatement(Guid?id)
{
var statement = _ctx.EMP_Statement.FirstOrDefault(x => x.Id == id) ?? new EMP_Statement()
{
Agreement = "Гарантирую: достоверность и идентичность информации, содержащейся в регистрационном досье и заявлении, представление образцов изделий медицинского назначения, стандартных образцов в количествах, достаточных для трехкратного анализа, специфические реагенты, расходные материалы, применяемые при проведении испытаний (в исключительных случаях и на условиях возврата), а также их соответствие нормативным документам, представляемым на регистрацию. Обязуюсь сообщать обо всех изменениях в регистрационное досье, а также представлять заявление и материалы при обнаружении побочных воздействий при применении изделия медицинского назначения, медицинской техники, ранее не указанных в инструкции по медицинскому применению изделий медицинского назначения / руководстве по эксплуатации медицинской техники."
};
var changes = _ctx.EMP_StatementChange.Where(x => x.StatementId == statement.Id).ToList();
var storageLifes = _ctx.EMP_StatementStorageLife.Where(x => x.StatementId == statement.Id).ToList();
var countryRegistrations = _ctx.EMP_StatementCountryRegistration.Where(x => x.StatementId == statement.Id).ToList();
var complectations = _ctx.EMP_StatementMedicalDeviceComplectation.Where(x => x.StatementId == statement.Id).ToList();
var packages = _ctx.EMP_StatementMedicalDevicePackage.Where(x => x.StatementId == statement.Id).ToList();
var statementVm = new EmpStatementViewModel
{
Id = statement.Id,
RegistrationKindValue = statement.RegistrationKindValue,
RegistrationKind = new List <SelectListItem>
{
new SelectListItem {
Value = "1", Text = "Регистрация"
},
new SelectListItem {
Value = "2", Text = "Перерегистрация"
},
new SelectListItem {
Value = "3", Text = "Внесение изменений"
}
},
RegistrationCertificateNumber = statement.RegistrationCertificateNumber,
NormativeDocumentNumber = statement.NormativeDocumentNumber,
RegistrationDate = statement.RegistrationDate,
ExpirationDate = statement.ExpirationDate == DateTime.MinValue ? DateTime.Now : statement.ExpirationDate,
ChangeData = changes.Select(x => new EmpStatementChangeViewModel
{
Id = x.Id,
Name = x.Name,
Type = x.Type,
BeforeChange = x.BeforeChange,
AfterChange = x.AfterChange
}).ToList(),
ContractId = statement.ContractId,
CortractList = _ctx.EMP_Contract
.Where(c => c.EMP_Ref_ContractScope.Code == "national")
.Select(x => new SelectListItem
{
Value = x.Id.ToString(),
Text = x.Number + " " + x.MedicalDeviceName
}).ToList(),
RegistrationTypeValue = statement.RegistrationTypeValue,
RegistrationType = new List <SelectListItem>
{
new SelectListItem {
Value = "1", Text = "Ускоренная"
},
new SelectListItem {
Value = "2", Text = "Обычная"
}
},
LetterNumber = statement.LetterNumber,
LetterDate = statement.LetterDate ?? DateTime.Now,
IsMt = statement.IsMt ?? false,
MedicalDeviceNameKz = statement.MedicalDeviceNameKz,
MedicalDeviceNameRu = statement.MedicalDeviceNameRu,
NomenclatureCode = statement.NomenclatureCode,
NmirkId = statement.NmirkId,
NomenclatureNameKz = statement.NomenclatureNameKz,
NomenclatureNameRu = statement.NomenclatureNameRu,
NomenclatureDescriptionKz = statement.NomenclatureDescriptionKz,
NomenclatureDescriptionRu = statement.NomenclatureDescriptionRu,
ApplicationAreaKz = statement.ApplicationAreaKz?.Split(",".ToCharArray())?.ToList(),
ApplicationAreaRu = statement.ApplicationAreaRu?.Split(",".ToCharArray())?.ToList(),
PurposeKz = statement.PurposeKz,
PurposeRu = statement.PurposeRu,
IsClosedSystem = statement.IsClosedSystem ?? false,
RegistrationDossierPageNumber = statement.RegistrationDossierPageNumber,
ShortTechnicalCharacteristicKz = statement.ShortTechnicalCharacteristicKz,
ShortTechnicalCharacteristicRu = statement.ShortTechnicalCharacteristicRu,
ClassOfPotentialRisk = statement.ClassOfPotentialRisk,
IsBalk = statement.IsBalk ?? false,
IsMeasurementDevice = statement.IsMeasurementDevice ?? false,
IsForInvitroDiagnostics = statement.IsForInvitroDiagnostics ?? false,
IsSterile = statement.IsSterile ?? false,
IsMedicalProductPresence = statement.IsMedicalProductPresence ?? false,
WithouAe = statement.WithouAe ?? false,
StorageLifeData = storageLifes.Select(x => new EmpStatementStorageLifeViewModel
{
Id = x.Id,
Kind = x.Kind,
ExpirationDate = x.ExpirationDate,
Measure = x.Measure,
IsIndefinitely = x.IsIndefinitely ?? false
}).ToList(),
TransportConditions = statement.TransportConditions,
StorageConditions = statement.StorageConditions,
CountryRegistrationData = countryRegistrations.Select(x => new EmpStatementCountryRegistrationViewModel
{
Id = x.Id,
Country = x.Country,
RegistrationNumber = x.RegistrationNumber,
StartDate = x.StartDate,
ExpirationDate = x.ExpirationDate,
IsIndefinitely = x.IsIndefinitely ?? false
}).ToList(),
Production = statement.Production,
MedicalDeviceComplectationData = complectations.Select(x => new EmpStatementMedicalDeviceComplectationViewModel
{
Id = x.Id,
Type = x.Type,
Name = x.Name,
Identifier = x.Identifier,
Model = x.Model,
Manufacturer = x.Manufacturer,
Country = x.Country
}).ToList(),
MedicalDevicePackageData = packages.Select(x => new EmpStatementMedicalDevicePackageViewModel
{
Id = x.Id,
Kind = x.Kind,
Name = x.Name,
VolumeValue = x.VolumeValue,
VolumeUnit = x.VolumeUnit,
Count = x.Count ?? 0,
Description = x.Description
}).ToList(),
IsComplectation = statement.IsComplectation ?? false,
ManufacturerType = statement.ManufacturerType,
ManufacturerNameRu = statement.ManufacturerNameRu,
AllowedDocumentNumber = statement.AllowedDocumentNumber,
BossLastName = statement.BossLastName,
BossPosition = statement.BossPosition,
OrganizationForm = statement.OrganizationForm,
ManufacturerNameKz = statement.ManufacturerNameKz,
DateOfIssue = statement.DateOfIssue,
BossFirstName = statement.BossFirstName,
Phone = statement.Phone,
Country = statement.Country,
ManufacturerNameEn = statement.ManufacturerNameEn,
ManufacturerExpirationDate = statement.ManufacturerExpirationDate,
BossMiddleName = statement.BossMiddleName,
Email = statement.Email,
ContactPersonInitials = statement.ContactPersonInitials,
ContactPersonLegalAddress = statement.ContactPersonLegalAddress,
ContactPersonPosition = statement.ContactPersonPosition,
ContactPersonFactAddress = statement.ContactPersonFactAddress,
Agreement = statement.Agreement,
IsAgreed = statement.IsAgreed ?? false,
Samples = statement.EMP_StatementSamples.Select(s => new EmpStatementSampleVm
{
Id = s.Id,
Addition = s.Addition,
Conditions = s.Conditions,
Count = s.Count,
CreateDate = s.CreateDate,
ExpirationDate = s.ExpirationDate,
Name = s.Name,
SampleType = s.SampleType,
SeriesPart = s.SeriesPart,
Storage = s.Storage,
Unit = s.Unit
})
};
return(Json(statementVm, JsonRequestBehavior.AllowGet));
}
public ActionResult StatementSave(EmpStatementViewModel vm)
{
var statement = _ctx.EMP_Statement.FirstOrDefault(x => x.Id == vm.Id);
if (statement == null)
{
statement = new EMP_Statement {
Id = Guid.NewGuid()
};
_ctx.EMP_Statement.Add(statement);
}
statement.RegistrationKindValue = vm.RegistrationKindValue;
statement.RegistrationCertificateNumber = vm.RegistrationCertificateNumber;
statement.NormativeDocumentNumber = vm.NormativeDocumentNumber;
if (vm.RegistrationDate != null)
{
statement.RegistrationDate = vm.RegistrationDate;
}
if (vm.ExpirationDate != null)
{
statement.ExpirationDate = vm.ExpirationDate;
}
statement.ContractId = vm.ContractId;
statement.RegistrationTypeValue = vm.RegistrationTypeValue;
statement.LetterNumber = vm.LetterNumber;
if (vm.LetterDate != null)
{
statement.LetterDate = vm.LetterDate;
}
statement.IsMt = vm.IsMt;
statement.MedicalDeviceNameKz = vm.MedicalDeviceNameKz;
statement.MedicalDeviceNameRu = vm.MedicalDeviceNameRu;
statement.NomenclatureCode = vm.NomenclatureCode;
statement.NmirkId = vm.NmirkId;
statement.NomenclatureNameKz = vm.NomenclatureNameKz;
statement.NomenclatureNameRu = vm.NomenclatureNameRu;
statement.NomenclatureDescriptionKz = vm.NomenclatureDescriptionKz;
statement.NomenclatureDescriptionRu = vm.NomenclatureDescriptionRu;
statement.ApplicationAreaKz = string.Join(",", vm.ApplicationAreaKz);
statement.ApplicationAreaRu = string.Join(",", vm.ApplicationAreaRu);
statement.PurposeKz = vm.PurposeKz;
statement.PurposeRu = vm.PurposeRu;
statement.IsClosedSystem = vm.IsClosedSystem;
statement.RegistrationDossierPageNumber = vm.RegistrationDossierPageNumber;
statement.ShortTechnicalCharacteristicKz = vm.ShortTechnicalCharacteristicKz;
statement.ShortTechnicalCharacteristicRu = vm.ShortTechnicalCharacteristicRu;
statement.ClassOfPotentialRisk = vm.ClassOfPotentialRisk;
statement.IsBalk = vm.IsBalk;
statement.IsMeasurementDevice = vm.IsMeasurementDevice;
statement.IsForInvitroDiagnostics = vm.IsForInvitroDiagnostics;
statement.IsSterile = vm.IsSterile;
statement.IsMedicalProductPresence = vm.IsMedicalProductPresence;
statement.WithouAe = vm.WithouAe;
statement.TransportConditions = vm.TransportConditions;
statement.StorageConditions = vm.StorageConditions;
statement.Production = vm.Production;
statement.IsComplectation = vm.IsComplectation;
statement.ManufacturerType = vm.ManufacturerType;
statement.ManufacturerNameRu = vm.ManufacturerNameRu;
statement.AllowedDocumentNumber = vm.AllowedDocumentNumber;
statement.BossLastName = vm.BossLastName;
statement.BossPosition = vm.BossPosition;
statement.OrganizationForm = vm.OrganizationForm;
statement.ManufacturerNameKz = vm.ManufacturerNameKz;
if (vm.DateOfIssue != null)
{
statement.DateOfIssue = vm.DateOfIssue;
}
statement.BossFirstName = vm.BossFirstName;
statement.Phone = vm.Phone;
statement.Country = vm.Country;
statement.ManufacturerNameEn = vm.ManufacturerNameEn;
if (vm.ManufacturerExpirationDate != null)
{
statement.ManufacturerExpirationDate = vm.ManufacturerExpirationDate;
}
statement.BossMiddleName = vm.BossMiddleName;
statement.Email = vm.Email;
statement.ContactPersonInitials = vm.ContactPersonInitials;
statement.ContactPersonLegalAddress = vm.ContactPersonLegalAddress;
statement.ContactPersonPosition = vm.ContactPersonPosition;
statement.ContactPersonFactAddress = vm.ContactPersonFactAddress;
statement.Agreement = vm.Agreement;
statement.IsAgreed = vm.IsAgreed;
if (vm.ChangeData != null)
{
var changes = _ctx.EMP_StatementChange.Where(x => x.StatementId == statement.Id).ToList();
foreach (var changeVm in vm.ChangeData)
{
var change = changes.FirstOrDefault(x => x.Id == changeVm.Id);
if (change == null)
{
change = new EMP_StatementChange {
Id = Guid.NewGuid(), StatementId = statement.Id
};
_ctx.EMP_StatementChange.Add(change);
}
change.Name = changeVm.Name;
change.Type = changeVm.Type;
change.BeforeChange = changeVm.BeforeChange;
change.AfterChange = changeVm.AfterChange;
}
}
if (vm.StorageLifeData != null)
{
var storageLifes = _ctx.EMP_StatementStorageLife.Where(x => x.StatementId == statement.Id).ToList();
foreach (var storageLifeVm in vm.StorageLifeData)
{
var storageLife = storageLifes.FirstOrDefault(x => x.Id == storageLifeVm.Id);
if (storageLife == null)
{
storageLife = new EMP_StatementStorageLife {
Id = Guid.NewGuid(), StatementId = statement.Id
};
_ctx.EMP_StatementStorageLife.Add(storageLife);
}
storageLife.Kind = storageLifeVm.Kind;
if (storageLifeVm.ExpirationDate != null)
{
storageLife.ExpirationDate = storageLifeVm.ExpirationDate;
}
storageLife.Measure = storageLifeVm.Measure;
storageLife.IsIndefinitely = storageLifeVm.IsIndefinitely;
}
}
if (vm.CountryRegistrationData != null)
{
var countryRegistrations = _ctx.EMP_StatementCountryRegistration.Where(x => x.StatementId == statement.Id).ToList();
foreach (var countryRegistrationVm in vm.CountryRegistrationData)
{
var countryRegistration = countryRegistrations.FirstOrDefault(x => x.Id == countryRegistrationVm.Id);
if (countryRegistration == null)
{
countryRegistration = new EMP_StatementCountryRegistration {
Id = Guid.NewGuid(), StatementId = statement.Id
};
_ctx.EMP_StatementCountryRegistration.Add(countryRegistration);
}
countryRegistration.Country = countryRegistrationVm.Country;
countryRegistration.RegistrationNumber = countryRegistrationVm.RegistrationNumber;
if (countryRegistrationVm.StartDate != null)
{
countryRegistration.StartDate = countryRegistrationVm.StartDate;
}
if (countryRegistrationVm.ExpirationDate != null)
{
countryRegistration.ExpirationDate = countryRegistrationVm.ExpirationDate;
}
countryRegistration.IsIndefinitely = countryRegistrationVm.IsIndefinitely;
}
}
if (vm.MedicalDeviceComplectationData != null)
{
var complectations = _ctx.EMP_StatementMedicalDeviceComplectation.Where(x => x.StatementId == statement.Id).ToList();
foreach (var complectationVm in vm.MedicalDeviceComplectationData)
{
var complectation = complectations.FirstOrDefault(x => x.Id == complectationVm.Id);
if (complectation == null)
{
complectation = new EMP_StatementMedicalDeviceComplectation {
Id = Guid.NewGuid(), StatementId = statement.Id
};
_ctx.EMP_StatementMedicalDeviceComplectation.Add(complectation);
}
complectation.Type = complectationVm.Type;
complectation.Name = complectationVm.Name;
complectation.Identifier = complectationVm.Identifier;
complectation.Model = complectationVm.Model;
complectation.Manufacturer = complectationVm.Manufacturer;
complectation.Country = complectationVm.Country;
}
}
if (vm.MedicalDevicePackageData != null)
{
var packages = _ctx.EMP_StatementMedicalDevicePackage.Where(x => x.StatementId == statement.Id).ToList();
foreach (var packageVm in vm.MedicalDevicePackageData)
{
var package = packages.FirstOrDefault(x => x.Id == packageVm.Id);
if (package == null)
{
package = new EMP_StatementMedicalDevicePackage {
Id = Guid.NewGuid(), StatementId = statement.Id
};
_ctx.EMP_StatementMedicalDevicePackage.Add(package);
}
package.Kind = packageVm.Kind;
package.Name = packageVm.Name;
package.VolumeValue = packageVm.VolumeValue;
package.VolumeUnit = packageVm.VolumeUnit;
package.Count = packageVm.Count;
package.Description = packageVm.Description;
}
}
if (vm.Samples != null)
{
statement.EMP_StatementSamples = vm.Samples.Select(s =>
{
var res = new EMP_StatementSamples
{
Addition = s.Addition,
Conditions = s.Conditions,
Count = s.Count,
CreateDate = s.CreateDate,
ExpirationDate = s.ExpirationDate,
Name = s.Name,
SampleType = s.SampleType,
SeriesPart = s.SeriesPart,
StatementId = vm.Id,
Storage = s.Storage,
Unit = s.Unit
};
if (s.Id != 0)
{
res.Id = s.Id;
}
return(res);
}).ToList();
}
_ctx.SaveChanges();
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}