private void saveTicket_Click(object sender, EventArgs e)
{
try
{
using (var context = new Cabinet_MedicalEntities())
{
var af = (from afect in context.Diseases
where afect.Denumire.Equals(diseaseBox.SelectedItem.ToString().Trim())
select afect.ID).ToList().First();
History_Patients hist = new History_Patients
{
ID_Afectiune = af,
ID_Pacient = pacient.ID,
ID_Medic = medic.ID,
Data = DateTime.Now
};
context.History_Patients.Add(hist);
context.SaveChanges();
Internment_Tickets bilet = new Internment_Tickets
{
ID_Istoric = hist.ID,
Descriere = diseaseBox.Text.ToString().Trim()
};
context.Internment_Tickets.Add(bilet);
context.SaveChanges();
MessageBox.Show("Biletul de trimitere a fost inregistrat!", "Succes!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Eroare!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
using (var context = new Cabinet_MedicalEntities())
{
string medic = textBoxMedic.Text;
string afectiune = textBoxAfectiune.Text;
int zile = Int32.Parse(textBoxZile.Text);
if (textBoxMedic.Text.Length == 0)
{
throw new Exception("Nu ati introdus numele medicului/asistentului!");
}
else if (textBoxAfectiune.Text.Length == 0)
{
throw new Exception("Nu ati introdus denumirea afectiunii!");
}
else if (textBoxZile.Text.Length == 0)
{
throw new Exception("Nu ati introdus numarul de zile!");
}
else if (textBoxTipScutire.Text.Length == 0)
{
throw new Exception("Nu ati introdus tipul scutirii!");
}
else
{
var query = (from m in context.Employees
where m.Nume.Equals(medic)
select m).FirstOrDefault();
var query2 = (from a in context.Diseases
where a.Denumire.Equals(afectiune)
select a).FirstOrDefault();
if (query2 == null)
{
throw new Exception("Denumirea afectiunii este incorecta!");
}
else if (query == null)
{
throw new Exception("Numele medicului introdus esti incorect!");
}
else
{
var addnew = new History_Patients
{
ID_Medic = query.ID,
Data = DateTime.Now,
ID_Pacient = Pacient.ID,
ID_Afectiune = query2.ID
};
context.History_Patients.Add(addnew);
context.SaveChanges();
var addsc = new Exemption
{
ID_Istoric = addnew.ID,
Zile_Repaus = zile,
Tip = textBoxTipScutire.Text
};
context.Exemptions.Add(addsc);
context.SaveChanges();
MessageBox.Show("Scutirea a fost inregistrata cu succes!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBoxAfectiune.Text = "";
textBoxMedic.Text = "";
textBoxTipScutire.Text = "";
textBoxZile.Text = "";
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
using (var context = new Cabinet_MedicalEntities())
{
try
{
if (textBoxAf.Text.Length == 0)
{
throw new Exception("Nu ati introdus denumirea afectiunii!");
}
else if (textBoxMed.Text.Length == 0)
{
throw new Exception("Nu ati introdus denumirea medicamentului!");
}
else if (textBoxNrF.Text.Length == 0)
{
throw new Exception("Nu ati introdus numarul de flacoane!");
}
else
{
var res = (from p in context.Drugs
where p.Denumire.Equals(textBoxMed.Text)
select p).FirstOrDefault();
int numar = Int32.Parse(textBoxNrF.Text);
var query2 = (from a in context.Diseases
where a.Denumire.Equals(textBoxAf.Text)
select a).FirstOrDefault();
if (query2 == null)
{
throw new Exception("Denumirea afectiunii este incorecta!");
}
string den = res.Denumire;
if (res.Stoc > numar)
{
var addnew = new History_Patients
{
ID_Medic = m.ID,
Data = DateTime.Now,
ID_Pacient = Pacient.ID,
ID_Afectiune = query2.ID
};
context.History_Patients.Add(addnew);
context.SaveChanges();
var addret = new Recipe
{
ID_Istoric = addnew.ID,
ID_Medicament = res.ID,
Numar_Flacoane = numar
};
context.Recipes.Add(addret);
context.SaveChanges();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
var pp = from dr in context.Drugs
where dr.Denumire.Equals(den)
select dr;
foreach (var pastile in pp)
{
pastile.Stoc = pastile.Stoc - numar;
}
context.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
}
}
MessageBox.Show("Reteta a fost inregistrata cu succes!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBoxAf.Text = "";
textBoxMed.Text = "";
textBoxNrF.Text = "";
}
else
{
MessageBox.Show("Stoc insuficient!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
