private void SaveSeries(int productId, List <OBKContractSeriesViewModel> list)
{
if (list != null && list.Count > 0)
{
foreach (OBKContractSeriesViewModel item in list)
{
OBK_Procunts_Series newSerie = new OBK_Procunts_Series();
newSerie.Series = item.Series;
newSerie.SeriesEndDate = item.CreateDate;
newSerie.SeriesStartdate = item.ExpireDate;
newSerie.SeriesParty = item.Part;
newSerie.SeriesMeasureId = item.UnitId;
newSerie.OBK_RS_ProductsId = productId;
AppContext.OBK_Procunts_Series.Add(newSerie);
AppContext.SaveChanges();
}
}
}
public virtual ActionResult GetContract(Guid id)
{
var contract = new SafetyAssessmentRepository().GetContractById(id);
if (contract == null)
{
return(Json(new { isSuccess = false }));
}
var products = new SafetyAssessmentRepository().GetRsProductsAndSeries(contract.Id);
var result = new OBK_AssessmentDeclaration();
var resultProducts = new List <OBK_RS_Products>();
foreach (var product in products)
{
var prod = new OBK_RS_Products();
prod.Id = product.Id;
prod.NameRu = product.NameRu;
prod.NameKz = product.NameKz;
prod.ProducerNameRu = product.ProducerNameRu;
prod.ProducerNameKz = product.ProducerNameKz;
prod.CountryNameRu = product.CountryNameRu;
prod.CountryNameKZ = product.CountryNameKZ;
prod.DrugFormFullName = product.DrugFormFullName;
prod.DrugFormFullNameKz = product.DrugFormFullNameKz;
prod.DrugFormBoxCount = product.DrugFormBoxCount;
//prod.TnvedCode = product.TnvedCode;
//prod.KpvedCode = product.KpvedCode;
prod.CurrencyId = product.CurrencyId;
prod.Price = product.Price;
prod.RegTypeId = product.RegTypeId;
prod.RegNumber = product.RegNumber;
prod.RegisterId = product.RegisterId;
prod.RegNumberKz = product.RegNumberKz;
prod.RegDate = product.RegDate;
prod.ExpirationDate = product.ExpirationDate;
prod.NdName = product.NdName;
prod.NdNumber = product.NdNumber;
prod.Dimension = product.Dimension;
prod.ExpertisePlace = product.ExpertisePlace;
foreach (var productSeries in product.OBK_Procunts_Series)
{
var prodSeries = new OBK_Procunts_Series();
prodSeries.Id = productSeries.Id;
prodSeries.Series = productSeries.Series;
prodSeries.SeriesStartdate = productSeries.SeriesStartdate;
prodSeries.SeriesEndDate = productSeries.SeriesEndDate;
prodSeries.SeriesParty = productSeries.SeriesParty;
prodSeries.SeriesShortNameRu = productSeries.sr_measures.short_name;
var obkStageExpDocumentSeries = new SafetyAssessmentRepository().GetStageExpDocument(prodSeries.Id);
if (obkStageExpDocumentSeries != null)
{
prodSeries.ExpId = obkStageExpDocumentSeries.Id;
prodSeries.ProductSeriesId = obkStageExpDocumentSeries.ProductSeriesId;
prodSeries.ExpResult = obkStageExpDocumentSeries.ExpResult ? "True" : "False";
prodSeries.ExpResultTitle = obkStageExpDocumentSeries.ExpResult
? "Соответствует требованиям"
: "Не соответствует требованиям";
prodSeries.ExpStartDate = string.Format("{0:dd.MM.yyyy}", obkStageExpDocumentSeries.ExpStartDate);
prodSeries.ExpEndDate = string.Format("{0:dd.MM.yyyy}", obkStageExpDocumentSeries.ExpEndDate);
prodSeries.ExpReasonNameRu = obkStageExpDocumentSeries.ExpReasonNameRu;
prodSeries.ExpReasonNameKz = obkStageExpDocumentSeries.ExpReasonNameKz;
prodSeries.ExpProductNameRu = obkStageExpDocumentSeries.ExpProductNameRu;
prodSeries.ExpProductNameKz = obkStageExpDocumentSeries.ExpProductNameKz;
prodSeries.ExpNomenclatureRu = obkStageExpDocumentSeries.ExpNomenclatureRu;
prodSeries.ExpNomenclatureKz = obkStageExpDocumentSeries.ExpNomenclatureKz;
prodSeries.ExpAddInfoRu = obkStageExpDocumentSeries.ExpAddInfoRu;
prodSeries.ExpAddInfoKz = obkStageExpDocumentSeries.ExpAddInfoKz;
prodSeries.ExpConclusionNumber = obkStageExpDocumentSeries.ExpConclusionNumber;
prodSeries.ExpBlankNumber = obkStageExpDocumentSeries.ExpBlankNumber;
prodSeries.ExpApplication = obkStageExpDocumentSeries.ExpApplication;
prodSeries.ExpApplicationNumber = obkStageExpDocumentSeries.ExpApplicationNumber;
}
prod.OBK_Procunts_Series.Add(prodSeries);
}
foreach (var mtPart in product.OBK_MtPart)
{
var mtParts = new OBK_MtPart();
mtParts.PartNumber = mtPart.PartNumber;
mtParts.Model = mtPart.Model;
mtParts.Specification = mtPart.Specification;
mtParts.ProducerName = mtPart.ProducerName;
mtParts.CountryName = mtPart.CountryName;
mtParts.Name = mtPart.Name;
prod.OBK_MtPart.Add(mtParts);
}
resultProducts.Add(prod);
}
result.ObkRsProductses = resultProducts;
return(Json(new { isSuccess = true, result }));
}
private void FillDeclarationControl(OBK_AssessmentDeclaration model)
{
var safetyRepository = new SafetyAssessmentRepository();
ViewData["ContractList"] =
new SelectList(safetyRepository.GetActiveContractListWithInfo(model.EmployeeId, model.Type_Id), "Id",
"ContractInfo", model.Contract_Id);
if (model.Type_Id == int.Parse(CodeConstManager.OBK_SA_SERIAL))
{
ViewData["TypeList"] = new SelectList(safetyRepository.GetObkRefTypes(), "Id", "NameRu", model.Type_Id = safetyRepository.GetObkRefTypes(CodeConstManager.OBK_SA_SERIAL).Id);
}
if (model.Type_Id == int.Parse(CodeConstManager.OBK_SA_PARTY))
{
ViewData["TypeList"] = new SelectList(safetyRepository.GetObkRefTypes(), "Id", "NameRu", model.Type_Id = safetyRepository.GetObkRefTypes(CodeConstManager.OBK_SA_PARTY).Id);
}
if (model.Type_Id == int.Parse(CodeConstManager.OBK_SA_DECLARATION))
{
ViewData["TypeList"] = new SelectList(safetyRepository.GetObkRefTypes(), "Id", "NameRu", model.Type_Id = safetyRepository.GetObkRefTypes(CodeConstManager.OBK_SA_DECLARATION).Id);
}
if (model.Contract_Id != null)
{
var contract = safetyRepository.GetContractById(model.Contract_Id);
var declarant = safetyRepository.GetDeclarantById(contract.DeclarantId);
var declarantContact = safetyRepository.GetDeclarantContactById(contract.DeclarantContactId);
var products = safetyRepository.GetRsProductsAndSeries(contract.Id);
//справочник стран
var countries = safetyRepository.GetCounties();
if (declarant?.CountryId == null)
{
ViewData["Counties"] = new SelectList(countries, "Id", "Name");
}
else
{
ViewData["Counties"] = new SelectList(countries, "Id", "Name",
model.CountryId = declarant.CountryId);
}
//Валюта
var currency = safetyRepository.GetObkCurrencies();
if (declarantContact?.CurrencyId == null)
{
ViewData["Courrency"] = new SelectList(currency, "Id", "Name");
}
else
{
ViewData["Courrency"] = new SelectList(currency, "Id", "Name",
model.CurrencyId = declarantContact.CurrencyId);
}
//Наличие сертификата GMP
var repository = new ReadOnlyDictionaryRepository();
var booleans = repository.GetCertificateGMPCheck();
ViewData["IsGMPList"] = new SelectList(booleans, "CertificateGMPCheck", "NameRu",
model.CertificateGMPCheck);
var certType = safetyRepository.GetCertificateType();
if (model.CertificateTypeId == null)
{
ViewData["CertificateType"] = new SelectList(certType, "Id", "NameRu");
}
else
{
ViewData["CertificateType"] = new SelectList(certType, "Id", "NameRu", model.CertificateTypeId);
}
//организационная форма
var orgForm = safetyRepository.GetOrganizationForm();
if (declarant?.OrganizationFormId == null)
{
ViewData["OrganizationForm"] = new SelectList(orgForm, "Id", "Name");
}
else
{
ViewData["OrganizationForm"] = new SelectList(orgForm, "Id", "Name",
model.OrganizationFormId = declarant.OrganizationFormId);
}
model.StartDate = string.Format("{0:dd.MM.yyyy}", contract.StartDate);
model.EndDate = string.Format("{0:dd.MM.yyyy}", contract.EndDate);
model.NameKz = declarant?.NameKz ?? "нет данных";
model.NameRu = declarant?.NameRu ?? "нет данных";
model.NameEn = declarant?.NameEn ?? "нет данных";
model.ChiefLastName = declarantContact?.BossLastName ?? "нет данных";
model.ChiefFirstName = declarantContact?.BossFirstName ?? "нет данных";
model.ChiefMiddleName = declarantContact?.BossMiddleName ?? "нет данных";
model.ChiefPosition = declarantContact?.BossPosition ?? "нет данных";
model.AddressFact = declarantContact?.AddressFact ?? "нет данных";
model.AddressLegal = declarantContact?.AddressLegalRu ?? "нет данных";
model.Phone = declarantContact?.Phone ?? "нет данных";
model.Email = declarantContact?.Email ?? "нет данных";
model.BankBik = declarantContact?.BankBik ?? "нет данных";
model.BankIik = declarantContact?.BankIik ?? "нет данных";
model.BankName = declarantContact?.BankNameRu ?? "нет данных";
var resultProducts = new List <OBK_RS_Products>();
foreach (var product in products)
{
var prod = new OBK_RS_Products();
prod.Id = product.Id;
prod.NameRu = product.NameRu;
prod.NameKz = product.NameKz;
prod.ProducerNameRu = product.ProducerNameRu;
prod.ProducerNameKz = product.ProducerNameKz;
prod.CountryNameRu = product.CountryNameRu;
prod.CountryNameKZ = product.CountryNameKZ;
prod.TnvedCode = product.TnvedCode;
prod.KpvedCode = product.KpvedCode;
prod.Price = product.Price;
foreach (var productSeries in product.OBK_Procunts_Series)
{
var prodSeries = new OBK_Procunts_Series();
prodSeries.Id = productSeries.Id;
prodSeries.Series = productSeries.Series;
prodSeries.SeriesStartdate = productSeries.SeriesStartdate;
prodSeries.SeriesEndDate = productSeries.SeriesEndDate;
prodSeries.SeriesParty = productSeries.SeriesParty;
prodSeries.SeriesShortNameRu = productSeries.sr_measures.short_name;
prod.OBK_Procunts_Series.Add(prodSeries);
}
resultProducts.Add(prod);
}
model.ObkRsProductses = resultProducts;
}
else
{
var countries = safetyRepository.GetCounties();
ViewData["Counties"] = new SelectList(countries, "Id", "Name");
//Валюта
var currency = safetyRepository.GetObkCurrencies();
ViewData["Courrency"] = new SelectList(currency, "Id", "Name");
var repository = new ReadOnlyDictionaryRepository();
//Наличие сертификата GMP
var booleans = repository.GetCertificateGMPCheck();
ViewData["IsGMPList"] = new SelectList(booleans, "CertificateGMPCheck", "NameRu",
model.CertificateGMPCheck);
var certType = safetyRepository.GetCertificateType();
ViewData["CertificateType"] = new SelectList(certType, "Id", "NameRu");
//организационная форма
var orgForm = safetyRepository.GetOrganizationForm();
ViewData["OrganizationForm"] = new SelectList(orgForm, "Id", "Name");
}
}
public virtual ActionResult GetContract(Guid id)
{
var contract = new SafetyAssessmentRepository().GetContractById(id);
if (contract == null)
{
return(Json(new { isSuccess = false }));
}
var declarant = new SafetyAssessmentRepository().GetDeclarantById(contract.DeclarantId);
var declarantContact = new SafetyAssessmentRepository().GetDeclarantContactById(contract.DeclarantContactId);
var products = new SafetyAssessmentRepository().GetRsProductsAndSeries(contract.Id);
var result = new OBK_AssessmentDeclaration();
result.StartDate = string.Format("{0:dd.MM.yyyy}", contract.StartDate);
result.EndDate = string.Format("{0:dd.MM.yyyy}", contract.EndDate);
result.OrganizationFormId = declarant?.OrganizationFormId ?? null;
result.NameKz = declarant?.NameKz ?? "нет данных";
result.NameRu = declarant?.NameRu ?? "нет данных";
result.NameEn = declarant?.NameEn ?? "нет данных";
result.ChiefLastName = declarantContact?.BossLastName ?? "нет данных";
result.ChiefFirstName = declarantContact?.BossFirstName ?? "нет данных";
result.ChiefMiddleName = declarantContact?.BossMiddleName ?? "нет данных";
result.ChiefPosition = declarantContact?.BossPosition ?? "нет данных";
result.AddressFact = declarantContact?.AddressFact ?? "нет данных";
result.AddressLegal = declarantContact?.AddressLegalRu ?? "нет данных";
result.Phone = declarantContact?.Phone ?? "нет данных";
result.Email = declarantContact?.Email ?? "нет данных";
result.BankBik = declarantContact?.BankBik ?? "нет данных";
result.BankIik = declarantContact?.BankIik ?? "нет данных";
result.BankName = declarantContact?.BankNameRu ?? "нет данных";
result.CountryId = declarant?.CountryId ?? null;
result.CurrencyId = declarantContact?.CurrencyId ?? null;
var resultProducts = new List <OBK_RS_Products>();
foreach (var product in products)
{
var prod = new OBK_RS_Products();
prod.Id = product.Id;
prod.NameRu = product.NameRu;
prod.NameKz = product.NameKz;
prod.ProducerNameRu = product.ProducerNameRu;
prod.ProducerNameKz = product.ProducerNameKz;
prod.CountryNameRu = product.CountryNameRu;
prod.CountryNameKZ = product.CountryNameKZ;
prod.TnvedCode = product.TnvedCode;
prod.KpvedCode = product.KpvedCode;
prod.Price = product.Price;
prod.CurrencyId = product.CurrencyId;
prod.DrugFormBoxCount = product.DrugFormBoxCount;
prod.DrugFormFullName = product.DrugFormFullName;
prod.RegTypeId = product.RegTypeId;
foreach (var productSeries in product.OBK_Procunts_Series)
{
var prodSeries = new OBK_Procunts_Series();
prodSeries.Id = productSeries.Id;
prodSeries.Series = productSeries.Series;
prodSeries.SeriesStartdate = productSeries.SeriesStartdate;
prodSeries.SeriesEndDate = productSeries.SeriesEndDate;
prodSeries.SeriesParty = productSeries.SeriesParty;
prodSeries.SeriesShortNameRu = productSeries.sr_measures.short_name;
prod.OBK_Procunts_Series.Add(prodSeries);
}
foreach (var mtPart in product.OBK_MtPart)
{
var mtParts = new OBK_MtPart();
mtParts.PartNumber = mtPart.PartNumber;
mtParts.Model = mtPart.Model;
mtParts.Specification = mtPart.Specification;
mtParts.ProducerName = mtPart.ProducerName;
mtParts.CountryName = mtPart.CountryName;
mtParts.Name = mtPart.Name;
prod.OBK_MtPart.Add(mtParts);
}
resultProducts.Add(prod);
}
result.ObkRsProductses = resultProducts;
return(Json(new { isSuccess = true, result }));
}
public virtual ActionResult GetProducts(Guid id)
{
var declarant = expRepo.GetAssessmentDeclaration(id);
if (declarant == null)
{
return(Json(new { isSuccess = false }));
}
//есть ли результат
var obkStageExpDocumentResult = new SafetyAssessmentRepository().GetStageExpDocumentResult(declarant.Id);
if (obkStageExpDocumentResult != null)
{
// если результат положительный
if (obkStageExpDocumentResult.ExpResult)
{
var results = new List <OBK_Procunts_Series>();
foreach (var product in declarant.OBK_Contract.OBK_RS_Products)
{
foreach (var productSeries in product.OBK_Procunts_Series)
{
var series = new OBK_Procunts_Series();
series.Id = productSeries.Id;
series.Series = productSeries.Series;
series.SeriesStartdate = productSeries.SeriesStartdate;
DateTime endDate = new DateTime();
var validDate = DateTime.TryParse(productSeries.SeriesEndDate, out endDate);
var endDateString = productSeries.SeriesEndDate;
if (validDate == true)
{
endDate = endDate.AddMonths(1);
endDateString = endDate.ToString("dd.MM.yyyy");
}
series.SeriesEndDate = endDateString;
series.SeriesParty = productSeries.SeriesParty;
series.SeriesShortNameRu = productSeries.sr_measures.short_name;
series.SeriesNameRu = productSeries.Series + ", годен до " + endDateString +
", партия " + productSeries.SeriesParty + " " +
productSeries.SeriesShortNameRu;
series.NameRu = product.NameRu;
series.NameKz = product.NameKz;
series.ProducerNameRu = product.ProducerNameRu;
series.ProducerNameKz = product.ProducerNameKz;
series.CountryNameRu = product.CountryNameRu;
series.CountryNameKz = product.CountryNameKZ;
var obkStageExpDocumentSeries =
new SafetyAssessmentRepository().GetStageExpDocument(productSeries.Id);
if (obkStageExpDocumentSeries != null)
{
series.ExpId = obkStageExpDocumentSeries.Id;
series.ProductSeriesId = obkStageExpDocumentSeries.ProductSeriesId;
series.ExpResult = obkStageExpDocumentSeries.ExpResult ? "True" : "False";
series.ExpResultTitle = obkStageExpDocumentSeries.ExpResult
? "Соответствует требованиям"
: "Не соответствует требованиям";
series.ExpStartDate =
string.Format("{0:dd.MM.yyyy}", obkStageExpDocumentSeries.ExpStartDate);
series.ExpEndDate = endDateString;
series.ExpReasonNameRu = obkStageExpDocumentSeries.ExpReasonNameRu;
series.ExpReasonNameKz = obkStageExpDocumentSeries.ExpReasonNameKz;
series.ExpProductNameRu = obkStageExpDocumentSeries.ExpProductNameRu;
series.ExpProductNameKz = obkStageExpDocumentSeries.ExpProductNameKz;
series.ExpProductShortNameRu = obkStageExpDocumentSeries.ExpProductShortNameRu;
series.ExpProductShortNameKz = obkStageExpDocumentSeries.ExpProductShortNameKz;
series.ExpNomenclatureRu = obkStageExpDocumentSeries.ExpNomenclatureRu;
series.ExpNomenclatureKz = obkStageExpDocumentSeries.ExpNomenclatureKz;
series.ExpAddInfoRu = assessmentRepo.FormExpAdditionalInfo(declarant);
series.ExpAddInfoKz = assessmentRepo.FormExpAdditionalInfo(declarant, true);
series.ExpConclusionNumber = obkStageExpDocumentSeries.ExpConclusionNumber;
series.ExpBlankNumber = obkStageExpDocumentSeries.ExpBlankNumber;
series.ExpApplication = obkStageExpDocumentSeries.ExpApplication;
series.ExpApplicationNumber = obkStageExpDocumentSeries.ExpApplicationNumber;
}
else
{
series.ExpConclusionNumber = expRepo.GenerateNumber(id, productSeries.Id);
}
results.Add(series);
}
}
return(Json(new { isSuccess = true, results }));
}
else
{
var obkStageExpDocumentSeries =
new SafetyAssessmentRepository().GetStageExpDocument(declarant.Id);
if (obkStageExpDocumentSeries != null)
{
var series = new OBK_Procunts_Series();
series.ExpId = obkStageExpDocumentSeries.Id;
series.ProductSeriesId = obkStageExpDocumentSeries.ProductSeriesId;
series.ExpResult = obkStageExpDocumentSeries.ExpResult ? "True" : "False";
series.ExpResultTitle = obkStageExpDocumentSeries.ExpResult
? "Соответствует требованиям"
: "Не соответствует требованиям";
series.ExpStartDate =
string.Format("{0:dd.MM.yyyy}", obkStageExpDocumentSeries.ExpStartDate);
series.ExpEndDate =
string.Format("{0:dd.MM.yyyy}", obkStageExpDocumentSeries.ExpEndDate);
series.ExpReasonNameRu = obkStageExpDocumentSeries.ExpReasonNameRu;
series.ExpReasonNameKz = obkStageExpDocumentSeries.ExpReasonNameKz;
series.ExpProductNameRu = obkStageExpDocumentSeries.ExpProductNameRu;
series.ExpProductNameKz = obkStageExpDocumentSeries.ExpProductNameKz;
series.ExpNomenclatureRu = obkStageExpDocumentSeries.ExpNomenclatureRu;
series.ExpNomenclatureKz = obkStageExpDocumentSeries.ExpNomenclatureKz;
series.ExpAddInfoRu = obkStageExpDocumentSeries.ExpAddInfoRu;
series.ExpAddInfoKz = obkStageExpDocumentSeries.ExpAddInfoKz;
series.ExpConclusionNumber = obkStageExpDocumentSeries.ExpConclusionNumber;
series.ExpBlankNumber = obkStageExpDocumentSeries.ExpBlankNumber;
series.ExpApplication = obkStageExpDocumentSeries.ExpApplication;
series.ExpApplicationNumber = obkStageExpDocumentSeries.ExpApplicationNumber;
return(Json(new { isSuccess = true, series }));
}
return(Json(new { isSuccess = true }));
}
}
return(Json(new { isSuccess = true }));
}
