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; }