public ActionResult ActSelection(string id)
{
var assess = GetSaDeclarationById(id);
var model = new OBK_ActReception();
if (assess != null)
{
var temp = db.OBK_ActReception.FirstOrDefault(o => o.OBK_AssessmentDeclarationId == new Guid(id));
if (temp != null)
{
model = temp;
}
else
{
model.Id = Guid.NewGuid();
model.OBK_AssessmentDeclarationId = new Guid(id);
db.OBK_ActReception.Add(model);
db.SaveChanges();
}
}
var product = db.OBK_RS_Products.FirstOrDefault(o => o.ContractId == assess.ContractId);
if (model.Producer == null && product != null)
{
repository.UpdateAct(assess, "Producer", model.Id, product.ProducerNameRu,
UserHelper.GetCurrentEmployee().Id.ToString(), "Producer");
}
if (model.ActDate == null)
{
repository.UpdateAct(assess, "ActDate", model.Id, DateTime.Now.ToString(),
UserHelper.GetCurrentEmployee().Id.ToString(), "ActDate");
}
if (model.Declarer == null)
{
repository.UpdateAct(assess, "Declarer", model.Id, UserHelper.GetCurrentEmployee().DisplayName,
UserHelper.GetCurrentEmployee().Id.ToString(), "Declarer");;
}
ViewData["ContractId"] = assess.ContractId;
var safetyRepository = new SafetyAssessmentRepository();
ViewData["ProductSampleList"] =
new SelectList(safetyRepository.GetProductSamples(), "Id", "Name");
ViewData["InspectionInstalledList"] =
new SelectList(safetyRepository.GetInspectionInstalls(), "Id", "Name");
ViewData["PackageConditionList"] =
new SelectList(safetyRepository.GetPackageConditions(), "Id", "Name");
ViewData["StorageConditionsList"] =
new SelectList(safetyRepository.GetStorageConditions(), "Id", "Name");
ViewData["MarkingList"] =
new SelectList(safetyRepository.GetMarkings(), "Id", "Name");
ViewData["OBKApplicants"] =
new SelectList(safetyRepository.OBKApplicants(), "Id", "NameRU");
return(PartialView("ActSelectionView", model));
}
/// <summary>
/// подгузка данных
/// </summary>
/// <param name="model"></param>
public void FillDeclarationControl(OBK_AssessmentDeclaration model)
{
var safetyRepository = new SafetyAssessmentRepository();
ViewData["ContractList"] =
new SelectList(safetyRepository.GetActiveContractListWithInfo(model.EmployeeId, model.TypeId), "Id",
"ContractInfo", model.ContractId);
if (model.TypeId == int.Parse(CodeConstManager.OBK_SA_SERIAL))
{
ViewData["TypeList"] = new SelectList(safetyRepository.GetObkRefTypes(), "Id", "NameRu",
model.TypeId = safetyRepository.GetObkRefTypes(CodeConstManager.OBK_SA_SERIAL).Id);
}
if (model.TypeId == int.Parse(CodeConstManager.OBK_SA_PARTY))
{
ViewData["TypeList"] = new SelectList(safetyRepository.GetObkRefTypes(), "Id", "NameRu",
model.TypeId = safetyRepository.GetObkRefTypes(CodeConstManager.OBK_SA_PARTY).Id);
}
if (model.TypeId == int.Parse(CodeConstManager.OBK_SA_DECLARATION))
{
ViewData["TypeList"] = new SelectList(safetyRepository.GetObkRefTypes(), "Id", "NameRu",
model.TypeId = safetyRepository.GetObkRefTypes(CodeConstManager.OBK_SA_DECLARATION).Id);
}
if (model.ContractId != null)
{
var contract = safetyRepository.GetContractById(model.ContractId);
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 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);
}
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);
}
model.ContractStartDate = string.Format("{0:dd.MM.yyyy}", contract.StartDate);
model.ContractEndDate = 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 ?? "нет данных";
model.ObkContracts = contract;
model.ObkContracts.ObkRsProductCount = products.Count();
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");
}
}
/// <summary>
/// подача заявления
/// </summary>
/// <returns></returns>
public ActionResult Create(string type)
{
var actId = Guid.NewGuid();
var model = new OBK_AssessmentDeclaration
{
Id = Guid.NewGuid(),
EmployeeId = UserHelper.GetCurrentEmployee().Id,
StatusId = CodeConstManager.STATUS_DRAFT_ID,
ObkContracts = new OBK_Contract(),
ObkRsProductses = new List <OBK_RS_Products>()
};
model.CertificateDate = null;
model.CreatedDate = DateTime.Now;
var safetyRepository = new SafetyAssessmentRepository(false);
if (type == CodeConstManager.OBK_SA_SERIAL)
{
ViewData["TypeList"] = new SelectList(safetyRepository.GetObkRefTypes(), "Id", "NameRu",
model.TypeId = safetyRepository.GetObkRefTypes(CodeConstManager.OBK_SA_SERIAL).Id);
}
if (type == CodeConstManager.OBK_SA_PARTY)
{
ViewData["TypeList"] = new SelectList(safetyRepository.GetObkRefTypes(), "Id", "NameRu",
model.TypeId = safetyRepository.GetObkRefTypes(CodeConstManager.OBK_SA_PARTY).Id);
}
if (type == CodeConstManager.OBK_SA_DECLARATION)
{
ViewData["TypeList"] = new SelectList(safetyRepository.GetObkRefTypes(), "Id", "NameRu",
model.TypeId = safetyRepository.GetObkRefTypes(CodeConstManager.OBK_SA_DECLARATION).Id);
}
ViewData["ContractList"] =
new SelectList(safetyRepository.GetActiveContractListWithInfo(model.EmployeeId, safetyRepository.GetObkRefTypes(type).Id), "Id",
"ContractInfo", model.ContractId);
var repository = new ReadOnlyDictionaryRepository();
//огранизационная форма
var orgForm = safetyRepository.GetOrganizationForm();
ViewData["OrganizationForm"] = new SelectList(orgForm, "Id", "Name");
var certType = safetyRepository.GetCertificateType();
ViewData["CertificateType"] = new SelectList(certType, "Id", "NameRu");
//Наличие сертификата GMP
var booleans = repository.GetCertificateGMPCheck();
ViewData["IsGMPList"] = new SelectList(booleans, "CertificateGMPCheck", "NameRu", model.CertificateGMPCheck);
//справочник стран
var countries = safetyRepository.GetCounties();
ViewData["Counties"] = new SelectList(countries, "Id", "Name");
//Валюта
var currency = safetyRepository.GetObkCurrencies();
ViewData["Courrency"] = new SelectList(currency, "Id", "Name");
return(View(model));
}
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.ContractStartDate = string.Format("{0:dd.MM.yyyy}", contract.StartDate);
result.ContractEndDate = string.Format("{0:dd.MM.yyyy}", contract.EndDate);
result.ContractType = contract.Type;
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;
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;
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 UpdateModel(string code, int typeId, string modelId, string userId, long?recordId, string fieldName, string fieldValue, string fieldDisplay, Guid?actId)
{
var filter = new SafetyAssessmentRepository().UpdateModel(code, typeId, modelId, userId, recordId, fieldName, fieldValue, fieldDisplay, actId);
return(Json(new { Success = true, modelId = filter.ModelId, recordId = filter.RecordId, controlId = filter.ControlId }));
}
public SafetyAssessmentController()
{
repository = new SafetyAssessmentRepository();
}
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;
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 }));
}
