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