private void pridejZamestnanceButton_Click(object sender, EventArgs e) { if (ValidateForm()) { ZamestnanecModel model = new ZamestnanecModel(); model.Jmeno = jmenoTextBox.Text; model.Prijmeni = prijmeniTextBox.Text; model.PracovniEmail = pracovniEmailTextBox.Text; model.SoukromyEmail = soukromyEmailTextBox.Text; model.Doktorand = doktorandCheckBox.Checked; model.Uvazek = double.Parse(uvazekTextBox.Text); model.PracovniTelefon = pracovniTelefonTextBox.Text; model.SoukromyTelefon = soukromyTelefonTextBox.Text; GlobalConfig.Connection.VytvorZamestnance(model); WireUpLists(); jmenoTextBox.Text = ""; prijmeniTextBox.Text = ""; pracovniEmailTextBox.Text = ""; soukromyEmailTextBox.Text = ""; doktorandCheckBox.Checked = false; uvazekTextBox.Text = "0"; pracovniTelefonTextBox.Text = ""; soukromyTelefonTextBox.Text = ""; } else { MessageBox.Show("Neplatné informace"); } }
public ZamestnanecModel VytvorZamestnance(ZamestnanecModel model) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("Tajemnik"))) { var p = new DynamicParameters(); p.Add("@Jmeno", model.Jmeno); p.Add("@Prijmeni", model.Prijmeni); p.Add("@PracovniEmail", model.PracovniEmail); p.Add("@SoukromyEmail", model.SoukromyEmail); p.Add("@Doktorand", model.Doktorand); p.Add("@Uvazek", model.Uvazek); p.Add("@PracovniTelefon", model.PracovniTelefon); p.Add("@SoukromyTelefon", model.SoukromyTelefon); p.Add("@ID", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); connection.Execute("dbo.spZamestnanec_Insert", p, commandType: CommandType.StoredProcedure); model.ID = p.Get <int>("@ID"); return(model); } }