public JsonResult CreateDirectionPriceList(EXP_PriceListDirectionToPayView model)
{
DirectionToPayRepository repository = new DirectionToPayRepository();
// if (ModelState.IsValid)
{
EXP_DirectionToPays_PriceList m = new EXP_DirectionToPays_PriceList()
{
DirectionToPayId = model.DirectionToPayId.Value,
PriceListId = model.PriceListId.Value,
Price = model.Price,
Count = model.Count,
Total = model.Price * model.Count
};
var diretionToPay = repository.GetAsQuarable(d => d.Id == model.DirectionToPayId.Value).FirstOrDefault();
if (diretionToPay != null)
{
diretionToPay.TotalPrice += m.Total;
repository.Update(diretionToPay);
}
repository.InsertDirectionPriceList(m);
repository.Save();
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public JsonResult ReadPriceList([DataSourceRequest] DataSourceRequest request)
{
DirectionToPayRepository repository = new DirectionToPayRepository(false);
var data = repository.GetPriceList();
return(Json(data.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateDirectionPriceList(EXP_PriceListDirectionToPayView model)
{
if (ModelState.IsValid)
{
DirectionToPayRepository repository = new DirectionToPayRepository();
EXP_DirectionToPays_PriceList m = repository.GetDirectionPriceList(dp => dp.DirectionToPayId == model.DirectionToPayId && dp.PriceListId == model.Id).FirstOrDefault();
if (m != null)
{
m.Count = model.Count;
m.Price = model.Price;
m.Total = model.Total;
repository.UpdateDirectionPriceList(m);
repository.Save();
}
var diretionToPay = repository.GetAsQuarable(d => d.Id == model.DirectionToPayId.Value).FirstOrDefault();
if (diretionToPay != null)
{
diretionToPay.TotalPrice = 0;
foreach (var pl in diretionToPay.EXP_DirectionToPays_PriceList)
{
diretionToPay.TotalPrice += pl.Total;
}
repository.Update(diretionToPay);
repository.Save();
}
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public override Guid GetExecutor(Guid documentId, Guid activityTypeId, int orderNum)
{
//return Guid.NewGuid();
const string ai = "abdukayumov.i"; //"19c786af-da7a-499d-b9ef-f17055029e3e";
const string nep = "nesipbaeva.g"; //2E9F5803-DE7F-4784-A391-FAE9C9E4E74D
DirectionToPayRepository repository = new DirectionToPayRepository(false);
var directionToPay = repository.GetAsQuarable(d => d.Id == documentId).FirstOrDefault();
if (directionToPay == null)
{
return(Guid.Empty);
}
if (directionToPay.Type == EXP_DirectionToPaysView.ExpertWorkType)
{
var emp = repository.GetEmployList().FirstOrDefault(e => e.Login == ai);
if (emp != null)
{
return(emp.Id);
}
}
else
{
var emp = repository.GetEmployList().FirstOrDefault(e => e.Login == nep);
if (emp != null)
{
return(emp.Id);
}
}
return(directionToPay.CreateEmployeeId);
}
public ActionResult GetPayerInfo(Guid directionId)
{
DirectionToPayRepository repository = new DirectionToPayRepository();
Organization payer = repository.GetPayerByDirectionId(directionId);
return(PartialView(payer));
}
public JsonResult DeleteDirection(EXP_DirectionToPaysView model)
{
if (model != null)
{
DirectionToPayRepository repository = new DirectionToPayRepository();
repository.Delete(model.Id);
repository.Save();
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public JsonResult ReadPriceListView([DataSourceRequest] DataSourceRequest request
, Guid?directionId)
{
DirectionToPayRepository repository = new DirectionToPayRepository();
var data = directionId == null
? repository.GetPriceListViews()
: repository.GetPriceListViews(dd => dd.DirectionToPayId == directionId.Value);
return(Json(data.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public JsonResult ReadDirectionList([DataSourceRequest] DataSourceRequest request)
{
DirectionToPayRepository repository = new DirectionToPayRepository();
var currentUserId = UserHelper.GetCurrentEmployee().Id;
var data = repository.GetDirectionToPaysViews(d => d.CreateEmployeeId == currentUserId || d.ExecutorId == currentUserId);
//var list = data.ToList();
return(Json(data.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public JsonResult ReadDrugDeclarationList([DataSourceRequest] DataSourceRequest request, int type)
{
DirectionToPayRepository repository = new DirectionToPayRepository(false);
var data = repository.GetDrugDeclarations(dd => dd.Number != null && !dd.EXP_DirectionToPays.Any(d => d.Type == type && d.DeleteDate == null));
if (type == EXP_DirectionToPaysView.AdditionalTranslateType)
{
data = repository.GetDrugDeclarations(dd => dd.Number != null);
}
return(Json(data.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public void Execute(IJobExecutionContext context)
{
DirectionToPayRepository repository = new DirectionToPayRepository(false);
var cancelStatus = repository
.GetDirectionToPayStatuses()
.FirstOrDefault(s => s.Code == Dictionary.ExpDirectionToPayStatus.Canceled && s.ExpireDate == null);
if (cancelStatus != null)
{
// TODO 40 дней перенести в настройки
var sqlScript = string.Format(@"UPDATE [dbo].[EXP_DirectionToPays] SET [StatusId] = '{0}', [StatusValue] = '{1}' WHERE [DirectionDate] < DATEADD(DAY, {2}, GETDATE()) AND StatusId <> '{0}'", cancelStatus.Id, cancelStatus.Name, "-40");
repository.RunSqlScript(sqlScript);
}
}
//DirectionToPayRepository _repository = new DirectionToPayRepository();
// GET: DirectionToPay
public ActionResult Index()
{
var guid = Guid.NewGuid();
DirectionToPayRepository repository = new DirectionToPayRepository();
ViewBag.DirectionToPayStatuses =
repository.GetDirectionToPayStatuses().ToList().OrderBy(o => o.Name)
.Select(o => new Item()
{
Id = o.Id.ToString(), Name = o.Name
}).ToList();
return(PartialView(guid));
}
public JsonResult ReadDrugDeclarationList([DataSourceRequest] DataSourceRequest request, int type)
{
DirectionToPayRepository repository = new DirectionToPayRepository(false);
var curentUserId = UserHelper.GetCurrentEmployee().Id;
var data = repository.GetDrugDeclarations(dd => dd.Number != null &&
!dd.EXP_DirectionToPays.Any(d => d.Type == type && d.DeleteDate == null) &&
dd.EXP_ExpertiseStage.Any(es => es.EXP_DIC_Stage.Code == EXP_DIC_Stage.PrimaryExp) &&
dd.EXP_ExpertiseStage.Any(es => es.EXP_ExpertiseStageExecutors.Any(ese => ese.ExecutorId == curentUserId)))
.Include(dd => dd.EXP_DIC_Type);
if (type == EXP_DirectionToPaysView.AdditionalTranslateType)
{
data = repository.GetDrugDeclarations(dd => dd.Number != null);
}
return(Json(data.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateDirection(EXP_DirectionToPaysView model)
{
if (ModelState.IsValid)
{
DirectionToPayRepository repository = new DirectionToPayRepository();
EXP_DirectionToPays m = repository.GetById(model.Id);
m.Number = model.Number;
m.DirectionDate = model.DirectionDate;
m.Type = model.Type;
m.TotalPrice = model.PageCount * m.PriceForPage;
m.PageCount = model.PageCount;
repository.Update(m);
repository.Save();
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Получить код Страны и Типа заявления
/// </summary>
/// <param name="repository">Репозиторий</param>
/// <param name="drugDeclaration">ИД Заявления</param>
/// <param name="countryCode">Код страны</param>
/// <param name="typeCode">Код типа</param>
/// <param name="countryCodes">Коды стран </param>
private void GetCountryCodeAndTypeCode(DirectionToPayRepository repository, EXP_DrugDeclaration drugDeclaration, out string countryCode, out string typeCode, ref List <string> countryCodes)
{
// Страна
countryCode = string.Empty;
if (drugDeclaration.EXP_DrugOrganizations != null)
{
foreach (var drugOrg in drugDeclaration.EXP_DrugOrganizations)
{
var isManufacturer = repository.GetOrgManufactureTypes().Any(mt => mt.Id == drugOrg.OrgManufactureTypeDicId &&
mt.Code == Dictionary.OrgManufactureType.Manufacturer);
if (drugOrg.CountryDicId != null && isManufacturer)
{
var cCode = repository.GetCountryCode(drugOrg.CountryDicId.Value);
countryCodes.Add(cCode);
countryCode = cCode;
}
}
}
// Тип заявления
typeCode = drugDeclaration.EXP_DIC_Type.Code;
}
public JsonResult DeleteDirectionPriceList(EXP_PriceListDirectionToPayView model)
{
if (model != null)
{
DirectionToPayRepository repository = new DirectionToPayRepository();
repository.DeleteDirectionPriceList(model.DirectionToPayId.Value, model.Id);
repository.Save();
var diretionToPay = repository.GetAsQuarable(d => d.Id == model.DirectionToPayId.Value).FirstOrDefault();
if (diretionToPay != null)
{
diretionToPay.TotalPrice = 0;
foreach (var pl in diretionToPay.EXP_DirectionToPays_PriceList)
{
diretionToPay.TotalPrice += pl.Total;
}
repository.Update(diretionToPay);
repository.Save();
}
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateCertificateOfCompletion(int stageId, Guid drugDeclarationId)
{
CertificateOfCompletionRepository repository = new CertificateOfCompletionRepository();
DictionaryRepository dictionary = new DictionaryRepository(false);
var newStatusId = dictionary.GetDictionaryElementIdByTypeAndCode(Dictionary.CertificateOfCompletionStatusDic.DicCode,
Dictionary.CertificateOfCompletionStatusDic.New);
DirectionToPayRepository directionRepository = new DirectionToPayRepository(false);
var directionToPay =
directionRepository.GetAsQuarable(
d => d.EXP_DrugDeclaration.Any(dd => dd.Id == drugDeclarationId) &&
d.Type == EXP_DirectionToPaysView.ExpertWorkType && d.DeleteDate == null).FirstOrDefault();
if (directionToPay != null)
{
var cert = repository.GetAsQuarable(coc => coc.DicStageId == stageId && coc.DrugDeclarationId == drugDeclarationId && coc.DeleteDate == null).FirstOrDefault();
bool isExist = cert != null;
if (!isExist)
{
cert = new EXP_CertificateOfCompletion()
{
Id = Guid.NewGuid(),
Number = Registrator.GetNumber("CertificateOfCompletion").ToString(),
CreateEmployeeId = UserHelper.GetCurrentEmployee().Id,
CreateDate = DateTime.Now,
DeleteDate = null,
ModifyDate = null,
SendDate = null,
StatusId = newStatusId,
DicStageId = stageId,
DrugDeclarationId = drugDeclarationId
}
}
;
switch (stageId)
{
case CodeConstManager.STAGE_PRIMARY:
cert.TotalPrice = directionToPay.TotalPrice * (decimal)0.7;
break;
case CodeConstManager.STAGE_SAFETYREPORT:
cert.TotalPrice = directionToPay.TotalPrice * (decimal)0.3;
break;
default:
break;
}
if (isExist)
{
repository.Update(cert);
}
else
{
repository.Insert(cert);
}
repository.Save();
}
else
{
return(Json(new { IsSuccess = false, Message = "Отсутствует направление на оплату" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { IsSuccess = true, Message = "" }, JsonRequestBehavior.AllowGet));
}
public JsonResult CreateDirection(EXP_DirectionToPaysView model)
{
DirectionToPayRepository repository = new DirectionToPayRepository();
if (ModelState.IsValid)
{
EXP_DirectionToPays m = new EXP_DirectionToPays()
{
Id = Guid.NewGuid(),
Number = Registrator.GetNumber("DirectionToPay").ToString(),
DirectionDate = model.DirectionDate,
Type = model.Type,
TypeValue = string.Empty,
//PayerId = ,
//PayerValue = ,
CreateEmployeeId = UserHelper.GetCurrentEmployee().Id,
CreateEmployeeValue = UserHelper.GetCurrentEmployee().DisplayName,
CreateDate = DateTime.Now
};
var status = repository.GetStatusByCode(Dictionary.ExpDirectionToPayStatus.Created);
m.StatusId = status.Id;
m.StatusValue = status.Name;
repository.Insert(m);
//repository.Save();
if (model.Type == 1)
{
if (model.DrugDeclarations != null)
{
foreach (var modelDrugDeclaration in model.DrugDeclarations)
{
var drugDeclaration = repository.GetDrugDeclarationById(modelDrugDeclaration.Id);
if (drugDeclaration != null)
{
m.EXP_DrugDeclaration.Add(drugDeclaration);
if (drugDeclaration.ContractId != null)
{
var payer = repository.GetPayerByContractId(drugDeclaration.ContractId.Value);
if (payer != null)
{
m.PayerId = payer.Id;
m.PayerValue = payer.Name;
}
}
m.EXP_DirectionToPays_PriceList = CreateDefaultPriceLists(drugDeclaration);
}
}
}
m.TotalPrice = 0;
foreach (var expDirectionToPaysPriceList in m.EXP_DirectionToPays_PriceList)
{
m.TotalPrice += expDirectionToPaysPriceList.Total;
}
}
else
{
if (model.DrugDeclarations != null)
{
foreach (var modelDrugDeclaration in model.DrugDeclarations)
{
var drugDeclaration = repository.GetDrugDeclarationById(modelDrugDeclaration.Id);
if (drugDeclaration != null)
{
m.EXP_DrugDeclaration.Add(drugDeclaration);
if (drugDeclaration.ContractId != null)
{
var payer = repository.GetPayerByContractId(drugDeclaration.ContractId.Value);
if (payer != null)
{
m.PayerId = payer.Id;
m.PayerValue = payer.Name;
}
}
}
}
}
m.TotalPrice = model.TotalPrice;
m.PageCount = model.PageCount;
m.PriceForPage = 2277;
}
repository.Save();
model.Id = m.Id;
model.Number = m.Number;
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
private List <EXP_DirectionToPays_PriceList> CreateDefaultPriceLists(EXP_DrugDeclaration drugDeclaration)
{
var priceLists = new List <EXP_DirectionToPays_PriceList>();
DirectionToPayRepository repository = new DirectionToPayRepository();
decimal?price = 0;
string countryCode, typeCode;
List <string> countryCodes = new List <string>();
/*
* // Страна
*
* if (drugDeclaration.EXP_DrugOrganizations != null)
* {
* foreach (var drugOrg in drugDeclaration.EXP_DrugOrganizations)
* {
* if (drugOrg.CountryDicId != null)
* {
* var cCode = repository.GetCountryCode(drugOrg.CountryDicId.Value);
* countryCodes.Add(cCode);
* countryCode = cCode;
* }
* }
* }
*
* // Тип заявления
* string typeCode = drugDeclaration.EXP_DIC_Type.Code;
*/
GetCountryCodeAndTypeCode(repository, drugDeclaration, out countryCode, out typeCode, ref countryCodes);
if (typeCode == TypeCodeConts.Alteration)
{
return(priceLists);
}
// Тип ЛС
var drugType = drugDeclaration.EXP_DrugType?.FirstOrDefault();
if (drugType != null)
{
var drugMapping = repository.GetPriceListMappingByDrugFormCode(drugType.EXP_DIC_DrugType.Code);
if (drugMapping != null)
{
if (drugDeclaration.EXP_DrugDosage != null)
{
// Многокомпонентный или однокомпонентный
int activeLsCount = 0;
int packageCount = 0;
foreach (var dosage in drugDeclaration.EXP_DrugDosage)
{
activeLsCount += dosage.EXP_DrugSubstance.Count;
packageCount += dosage.EXP_DrugWrapping.Count;
}
// однокомпонентный
string priceListNumber = drugMapping.PriceListCode;
// Многокомпонентный
if (activeLsCount > 1)
{
priceListNumber = drugMapping.PriceListMulticomponentCode;
}
var priceList = repository.GetPriceList(p => p.Category == null && p.Number == priceListNumber)
.FirstOrDefault();
if (priceList != null)
{
price = priceList.GetPrice(countryCode, typeCode);
priceLists.Add(new EXP_DirectionToPays_PriceList()
{
PriceListId = priceList.Id,
Count = 1,
Price = price,
Total = 1 * price
});
}
// Дополнительно каждой лекарственной дозы
var dosageCount = drugDeclaration.EXP_DrugDosage.Count;
if (dosageCount > 1)
{
var priceListNumberDc = priceListNumber + ".1";
var priceListAddDosage =
repository.GetPriceList(p => p.Category == null && p.Number == priceListNumberDc)
.FirstOrDefault();
if (priceListAddDosage != null)
{
price = priceListAddDosage.GetPrice(countryCode, typeCode);
priceLists.Add(new EXP_DirectionToPays_PriceList()
{
PriceListId = priceListAddDosage.Id,
Count = dosageCount,
Price = price,
Total = dosageCount * price
});
}
}
// Дополнительно каждой фасовки
if (packageCount > 1)
{
var priceListNumberDc = priceListNumber + ".2";
var priceListAddPackage =
repository.GetPriceList(p => p.Category == null && p.Number == priceListNumberDc)
.FirstOrDefault();
if (priceListAddPackage != null)
{
price = priceListAddPackage.GetPrice(countryCode, typeCode);
priceLists.Add(new EXP_DirectionToPays_PriceList()
{
PriceListId = priceListAddPackage.Id,
Count = packageCount,
Price = price,
Total = packageCount * price
});
}
}
}
}
}
return(priceLists);
}
public JsonResult GetPriceList(Guid directionId)
{
DirectionToPayRepository repository = new DirectionToPayRepository();
var priceListQuerable = repository.GetPriceList();
string countryCode = string.Empty;
List <string> countryCodes = new List <string>();
string typeCode = string.Empty;
//
var expDirectionToPays = repository.Get(d => d.Id == directionId).FirstOrDefault();
if (expDirectionToPays != null)
{
var drugDeclaration = expDirectionToPays.EXP_DrugDeclaration.FirstOrDefault();
GetCountryCodeAndTypeCode(repository, drugDeclaration, out countryCode, out typeCode, ref countryCodes);
/*
* // Страна
* List<string> countryCodes = new List<string>();
* if (drugDeclaration != null && drugDeclaration.EXP_DrugOrganizations != null)
* {
* foreach (var drugOrg in drugDeclaration.EXP_DrugOrganizations)
* {
* if (drugOrg.CountryDicId != null)
* {
* var cCode = repository.GetCountryCode(drugOrg.CountryDicId.Value);
* countryCodes.Add(cCode);
* countryCode = cCode;
* }
* }
* }
*
* // Тип заявления
* typeCode = drugDeclaration.EXP_DIC_Type.Code;
*/
}
if (countryCode == CountryCodeConts.KZ)
{
if (typeCode == TypeCodeConts.Registration)
{
return(Json(priceListQuerable.Where(p => p.Category == null).Select(p => new PriceListElementModel()
{
Id = p.Id
, Number = p.Number
, Name = p.NameRu
, Price = p.PriceRegisterKzNds
}).OrderBy(p => p.Number).ToList(), JsonRequestBehavior.AllowGet));
}
else if (typeCode == TypeCodeConts.ReRegistration)
{
return(Json(priceListQuerable.Where(p => p.Category == null).Select(p => new PriceListElementModel()
{
Id = p.Id
, Number = p.Number
, Name = p.NameRu
, Price = p.PriceReRegisterKzNds
}).OrderBy(p => p.Number).ToList(), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(priceListQuerable.Where(p => p.Category == "Внесение изменений в ЛС").Select(p => new PriceListElementModel()
{
Id = p.Id
, Number = p.Number
, Name = p.NameRu
, Price = p.PriceRegisterKzNds
}).OrderBy(p => p.Number).ToList(), JsonRequestBehavior.AllowGet));
}
}
else
{
if (typeCode == TypeCodeConts.Registration)
{
return(Json(priceListQuerable.Where(p => p.Category == null).Select(p => new PriceListElementModel()
{
Id = p.Id
, Number = p.Number
, Name = p.NameRu
, Price = p.PriceRegisterForeignNds
}).OrderBy(p => p.Number).ToList(), JsonRequestBehavior.AllowGet));
}
else if (typeCode == TypeCodeConts.ReRegistration)
{
return(Json(priceListQuerable.Where(p => p.Category == null).Select(p => new PriceListElementModel()
{
Id = p.Id
, Number = p.Number
, Name = p.NameRu
, Price = p.PriceReRegisterForeignNds
}).OrderBy(p => p.Number).ToList(), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(priceListQuerable.Where(p => p.Category == "Внесение изменений в ЛС").Select(p => new PriceListElementModel()
{
Id = p.Id
, Number = p.Number
, Name = p.NameRu
, Price = p.PriceRegisterForeignNds
}).OrderBy(p => p.Number).ToList(), JsonRequestBehavior.AllowGet));
}
}
}
