private void SaveMtParts(int productId, List <OBKContractMtPartViewModel> list)
{
if (list != null && list.Count > 0)
{
foreach (OBKContractMtPartViewModel item in list)
{
OBK_MtPart mtPart = new OBK_MtPart();
mtPart.Id = Guid.NewGuid();
mtPart.ProductId = productId;
mtPart.PartNumber = item.PartNumber;
mtPart.Model = item.Model;
mtPart.Specification = item.Specification;
mtPart.SpecificationKz = item.SpecificationKz;
mtPart.ProducerName = item.ProducerName;
mtPart.CountryName = item.CountryName;
mtPart.ProducerNameKz = item.ProducerNameKz;
mtPart.CountryNameKz = item.CountryNameKz;
AppContext.OBK_MtPart.Add(mtPart);
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 }));
}
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 }));
}
