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