public static void DeleteDisease(DiseaseEntity disease) { using (IDbConnection cnn = new MySqlConnection(loadConnectionString())) { cnn.Execute("delete from diseases where id = @Id", disease); } }
public static void SaveDisease(DiseaseEntity disease) { using (IDbConnection cnn = new MySqlConnection(loadConnectionString())) { cnn.Execute("insert into diseases (id, disease) values (@Id, @Disease)", disease); } }
private void setAddButton_Click(object sender, EventArgs e) { if (diseaseText.Text != "") { if (checkVxojdenie()) { DiseaseEntity diseaseEntity = new DiseaseEntity(DBAPI.getMAXDiseaseID() + 1, diseaseText.Text); DBAPI.SaveDisease(diseaseEntity); foreach (SymptomsComp s in symptomsComps) { if (s.isChecked()) { try { DBAPI.SaveMatch(new MatchesEntity(diseaseEntity.Id, s.Id, Double.Parse(s.Confidence.Text), Double.Parse(s.Distrust.Text))); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } clearDiseaseAdd(); setDiseaseAdd(); clearDiseaseList(); setDiseaseList(); } else { MessageBox.Show("Так нельзя"); } } }
public static DiseaseEntity getDiseaseID(DiseaseEntity disease) { using (IDbConnection cnn = new MySqlConnection(loadConnectionString())) { var output = cnn.Query <DiseaseEntity>("select id from diseases where diseases.disease like @disease", disease); return(output.ToList().First()); } }
public void InsertDisease(DiseaseEntity disease, IEnumerable <SynonymEntity> synonyms, IEnumerable <SummaryEntity> summaries) { using (var db = GetConnection()) { db.BeginTransaction(IsolationLevel.ReadCommitted); db.Insert(disease); db.InsertBatch(synonyms); db.InsertBatch(summaries); db.CompleteTransaction(); } }
public Disease(DiseaseEntity disease) { Name = disease.Name; Definition = disease.Definition; OrphaNumber = disease.OrphaNumber; Prevalence = disease.Prevalence; Inheritance = disease.Inheritance; AgeOfOnset = disease.AgeOfOnset; Icd10 = disease.Icd10; Omim = disease.Omim; Umls = disease.Umls; MeSH = disease.MeSH; Gard = disease.Gard; MedDra = disease.MedDra; }
private Disease PopulateDiseaseData(DiseaseEntity disease) { Disease result = new Disease(disease); result.Synonyms = _repository.GetSynonymsByDiseaseId(disease.Id.ToString()) .Select(s => new Synonym(s)) .ToList(); result.Summaries = _repository.GetSummariesByDiseaseId(disease.Id.ToString()) .Select(s => new Summary(s)) .ToList(); disease.State = 1; _exportedDiseases.Add(disease); return(result); }