public void Delete(string FIO)
{
Vrach pac = db14.Vrach.Where(c => c.FIO == FIO).FirstOrDefault();
db14.Vrach.DeleteOnSubmit(pac);
db14.SubmitChanges();
}
public void Edit(int ID, string FIO, int IDSpiskaDolj, int Zarplata, int VR, int Norma, int Premia)
{
Vrach pac = db14.Vrach.Where(c => c.ID == ID).FirstOrDefault();
pac.FIO = FIO;
pac.IDSpiskaDolj = IDSpiskaDolj;
pac.VR = VR;
pac.Norma = Norma;
pac.Premia = Premia;
pac.Zarplata = Zarplata;
db14.SubmitChanges();
}
public void ADD(string FIO, int IDSpiskaDolj, int Zarplata, string Data, int VR, int Norma, int Premia)
{
Vrach pac = new Vrach();
pac.FIO = FIO;
pac.IDSpiskaDolj = IDSpiskaDolj;
pac.Zarplata = Zarplata;
pac.Data = Data;
pac.VR = VR;
pac.Norma = Norma;
pac.Premia = Premia;
db14.Vrach.InsertOnSubmit(pac);
db14.SubmitChanges();
}