public void Delete(DiseaseDistroDetails distro, int userId)
{
OleDbConnection connection = new OleDbConnection(DatabaseData.Instance.AccessConnectionString);
using (connection)
{
connection.Open();
try
{
OleDbCommand command = new OleDbCommand(@"UPDATE DiseaseDistributions SET IsDeleted=@IsDeleted,
UpdatedById=@UpdatedById, UpdatedAt=@UpdatedAt WHERE ID=@id", connection);
command.Parameters.Add(new OleDbParameter("@IsDeleted", true));
command.Parameters.Add(new OleDbParameter("@UpdatedById", userId));
command.Parameters.Add(OleDbUtil.CreateDateTimeOleDbParameter("@UpdatedAt", DateTime.Now));
command.Parameters.Add(new OleDbParameter("@id", distro.Id));
command.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
public IView GetDiseaseDistro(DiseaseDistroDetails details)
{
DiseaseDistroCm model = diseases.GetDiseaseDistributionCm(details.Id, details.TypeId);
if (model.Disease.DiseaseType == Translations.CM)
return new DataEntryEdit(new DiseaseDistroCmVm(adminLevel, model, new CalcDistro()));
DiseaseDistroPc modelPc = diseases.GetDiseaseDistribution(details.Id, details.TypeId);
return new DataEntryEdit(new DiseaseDistroPcVm(adminLevel, modelPc, new CalcDistro()));
}
public void Delete(DiseaseDistroDetails details, int userId) { diseases.Delete(details, userId); }
private DiseaseDistroCm SplitDdCm(List<DiseaseDistroCm> toMerge, DiseaseDistroDetails details, AdminLevel dest, double multiplier, int redistrictId, OleDbCommand command, OleDbConnection connection)
{
var dd = diseaseRepo.GetDiseaseDistributionCm(details.Id, details.TypeId);
var newForm = Util.DeepClone(dd);
if (newForm.AdminLevelId != dest.Id)
{
newForm.Id = 0;
newForm.IsRedistricted = true;
newForm.AdminLevelId = dest.Id;
}
newForm.IndicatorValues = RedistributeIndicators(newForm.IndicatorValues, multiplier);
if (toMerge == null)
{
diseaseRepo.SaveCm(newForm, userId, connection, command);
demoRepo.InsertRedistrictForm(command, connection, userId, redistrictId, dd.Id, newForm.Id, IndicatorEntityType.DiseaseDistribution);
}
else
toMerge.Add(newForm);
return newForm;
}
