private void SaveBtn_Click(object sender, EventArgs e)
{
Cabinets temp = new Cabinets();
using (ClinicEntities1 db = new ClinicEntities1())
{
if (db.Cabinets.Find(id) == null)
{
Cabinets c = new Cabinets();
c.Id = id;
c.Name = NameTxtBx.Text;
c.Description = DescTxtBx.Text;
db.Cabinets.Add(c);
db.SaveChanges();
MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!");
this.Close();
}
else
{
var temp1 = db.Cabinets.Where(x => x.Id == id).FirstOrDefault <Cabinets>();
temp = temp1;
temp.Name = NameTxtBx.Text;
temp.Description = DescTxtBx.Text;
db.SaveChanges();
MessageBox.Show("Сохранение успешно", "Ортопедическая клиника");
this.Close();
}
}
}
private void CabinetLkLbl_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
Cabinets c = db.Cabinets.Where(x => x.Name == CabinetLkLbl.Text).FirstOrDefault <Cabinets>();
CabinetCard cc = new CabinetCard();
cc.Currentid = c.Id;
cc.ShowDialog();
}
}
private void RefreshFormData(int id)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
Cabinets temp = db.Cabinets.Where(x => x.Id == id).FirstOrDefault <Cabinets>();
CabinetNameLbl.Text = temp.Name;
DescriptionLbl.Text = temp.Description;
}
FillGrid();
}
private void DelBtn_Click(object sender, EventArgs e)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
Cabinets c = db.Cabinets.Where(x => x.Id == id).FirstOrDefault <Cabinets>();
c.DeleteTime = DateTime.Now;
MessageBox.Show("Кабинет успешно удален!", "Ортопедическая клиника");
db.SaveChanges();
this.Close();
}
}
private void CabinetEdit_Load(object sender, EventArgs e)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
if (db.Cabinets.Find(id) != null)
{
Cabinets temp = db.Cabinets.Where(x => x.Id == id).FirstOrDefault <Cabinets>();
NameTxtBx.Text = temp.Name;
DescTxtBx.Text = temp.Description;
FillGrid();
}
else
{
SaveBtn.Enabled = false;
Cabinets c = new Cabinets();
c.Id = db.Cabinets.Count() + 1;
Currentid = Convert.ToInt16(c.Id);
}
}
}
