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