private void TypeOfProcedureEdit_Load(object sender, EventArgs e)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
foreach (KindOfProcedures k in db.KindOfProcedures.ToList())
{
KOPcmbx.Items.Add(k.Name);
}
if (db.TypeOfProcedures.Find(id) != null)
{
TypeOfProcedures temp = db.TypeOfProcedures.Where(x => x.Id == id).FirstOrDefault <TypeOfProcedures>();
NameLbl.Text = temp.Name;
KOPcmbx.SelectedIndex = Convert.ToInt16(temp.KindOfProcedure_ID - 1);
PriceLbl.Text = Convert.ToString(temp.Price);
DescLbl.Text = temp.Description;
}
else
{
PriceLbl.Text = "0";
SaveBtn.Enabled = false;
TypeOfProcedures t = new TypeOfProcedures();
t.Id = db.TypeOfProcedures.Count() + 1;
Currentid = Convert.ToInt16(t.Id);
KOPcmbx.SelectedIndex = 0;
}
}
}
private void SaveBtn_Click(object sender, EventArgs e)
{
TypeOfProcedures temp = new TypeOfProcedures();
using (ClinicEntities1 db = new ClinicEntities1())
{
if (db.TypeOfProcedures.Find(id) == null)
{
TypeOfProcedures t = new TypeOfProcedures();
t.Id = id;
t.Name = NameLbl.Text;
t.KindOfProcedure_ID = db.KindOfProcedures.Find(KOPcmbx.SelectedIndex + 1).Id;
t.Price = Convert.ToDouble(PriceLbl.Text);
t.Description = DescLbl.Text;
db.TypeOfProcedures.Add(t);
db.SaveChanges();
MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!");
this.Close();
}
else
{
var temp1 = db.TypeOfProcedures.Where(x => x.Id == id).FirstOrDefault <TypeOfProcedures>();
temp = temp1;
temp.Name = NameLbl.Text;
temp.KindOfProcedure_ID = KOPcmbx.SelectedIndex + 1;
temp.Price = Convert.ToDouble(PriceLbl.Text);
temp.Description = DescLbl.Text;
db.SaveChanges();
MessageBox.Show("Сохранение успешно", "Ортопедическая клиника");
this.Close();
}
}
}
private void TOPLkLbl_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
TypeOfProcedures top = db.TypeOfProcedures.Where(x => x.Name == TOPLkLbl.Text).FirstOrDefault <TypeOfProcedures>();
TypeOfProcedureCard topc = new TypeOfProcedureCard();
topc.Currentid = top.Id;
topc.ShowDialog();
}
}
private void DelBtn_Click(object sender, EventArgs e)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
TypeOfProcedures t = db.TypeOfProcedures.Where(x => x.Id == id).FirstOrDefault <TypeOfProcedures>();
t.DeleteTime = DateTime.Now;
MessageBox.Show("Тип процедур успешно удален!", "Ортопедическая клиника");
db.SaveChanges();
this.Close();
}
}
private void RefreshFormData(int id)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
TypeOfProcedures temp = db.TypeOfProcedures.Where(x => x.Id == id).FirstOrDefault <TypeOfProcedures>();
NameLbl.Text = temp.Name;
KOP.Text = db.KindOfProcedures.Find(temp.KindOfProcedure_ID).Name;
PriceLbl.Text = Convert.ToString(temp.Price);
DescTxtBox.Text = temp.Description;
}
}
private void dataGridView7_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
TypeOfProcedureCard tpcard = new TypeOfProcedureCard();
int id = Convert.ToInt32(this.dataGridView7.CurrentRow.Cells[0].Value);
using (ClinicEntities1 db = new ClinicEntities1())
{
TypeOfProcedures t = db.TypeOfProcedures.Find(id);
tpcard.Currentid = id;
tpcard.ShowDialog();
FillGrid();
}
}
private void DelProcedure_Click(object sender, EventArgs e)
{
//int index = Convert.ToInt32(this.listBox2.SelectedIndex);
using (ClinicEntities1 db = new ClinicEntities1())
{
string typename = listBox2.SelectedItem.ToString();
TypeOfProcedures tp = db.TypeOfProcedures.Where(x => x.Name == typename).FirstOrDefault <TypeOfProcedures>();
WorkerTypeOfProcedures cp = db.WorkerTypeOfProcedures.Where(x => x.Worker_ID == id && x.TypeOfProcedure_ID == tp.Id).FirstOrDefault <WorkerTypeOfProcedures>();;
db.WorkerTypeOfProcedures.Remove(cp);
db.SaveChanges();
FillListBox();
}
}
