private void button1_Click(object sender, EventArgs e)
{
try
{
if (dalykopavadinimas.Text != "" && destytojoid.Text != "")
{
using (SqlConnection sqlCon = new SqlConnection(con))
{
sqlCon.Open();
dalykas dalykas = new dalykas();
dalykas.Dpavadinimas = dalykopavadinimas.Text.Trim();
dalykas.Did = Convert.ToInt32(destytojoid.Text.Trim());
//if () {
dalykas register = repos.Insertdalykas(dalykas);
}
Clear();
}
else
{
MessageBox.Show("All fields must be written");
}
void Clear()
{
dalykopavadinimas.Text = destytojoid.Text = "";
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
//prideda dalyka
public dalykas Insertdalykas(dalykas dalykas)
{
SqlConnection sqlCon = new SqlConnection(con);
sqlCon.Open();
/*SqlCommand cmd = new SqlCommand("SELECT * FROM [dalykas] WHERE username=@username", sqlCon);
* cmd.Parameters.AddWithValue("@username", student.Username);
* SqlDataReader dr = cmd.ExecuteReader();
* if (dr.Read() == true)
* {
* MessageBox.Show("The Username you chosen already exists, please select different username !");
* return null;
* }
* dr.Close();*/
SqlCommand sql = new SqlCommand("INSERT INTO [dalykas] (pavadinimas,destytojo_ID)" +
" VALUES (@pavadinimas,@destytojo_ID)", sqlCon);
sql.Parameters.AddWithValue("@pavadinimas", dalykas.Dpavadinimas);
sql.Parameters.AddWithValue("@destytojo_ID", dalykas.Did);
sql.ExecuteNonQuery();
sqlCon.Close();
return(dalykas);
}
