//prideda studijuojama grupe
public studijuojamasdalykas Insertstuddalyk(studijuojamasdalykas studdalyk)
{
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 [Studijuojamas_dalykas] (studento_ID,dalyko_ID)" +
" VALUES (@studento_ID,@dalyko_ID)", sqlCon);
sql.Parameters.AddWithValue("@studento_ID", studdalyk.SDstudentoID);
sql.Parameters.AddWithValue("@dalyko_ID", studdalyk.SDdalykoID);
sql.ExecuteNonQuery();
sqlCon.Close();
return(studdalyk);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (Astudentoid.Text != "" && Adalykoid.Text != "")
{
using (SqlConnection sqlCon = new SqlConnection(con))
{
sqlCon.Open();
studijuojamasdalykas studdalyk = new studijuojamasdalykas();
studdalyk.SDstudentoID = Convert.ToInt32(Astudentoid.Text.Trim());
studdalyk.SDdalykoID = Convert.ToInt32(Adalykoid.Text.Trim());
//if () {
//student.Grupe = Agrupe.Text.Trim();
studijuojamasdalykas register = repos.Insertstuddalyk(studdalyk);
}
Clear();
}
else
{
MessageBox.Show("All fields must be written");
}
void Clear()
{
Astudentoid.Text = Adalykoid.Text = "";
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
//ideti egza
public studijuojamasdalykas Insertegzas(studijuojamasdalykas ivertinimas)
{
studijuojamasdalykas ivertis = new studijuojamasdalykas();
SqlConnection sqlcon = new SqlConnection(con);
sqlcon.Open();
SqlCommand sql = new SqlCommand("UPDATE Studijuojamas_dalykas SET Egzas = @egzas WHERE studento_ID= @studento_ID AND dalyko_ID= @dalyko_ID ", sqlcon);
sql.Parameters.AddWithValue("@egzas", ivertinimas.SDegzas);
sql.Parameters.AddWithValue("@studento_ID", ivertinimas.SDstudentoID);
sql.Parameters.AddWithValue("@dalyko_ID", ivertinimas.SDdalykoID);
sql.ExecuteNonQuery();
sqlcon.Close();
return(ivertis);
}
//Iveda kontra
private void button1_Click(object sender, EventArgs e)
{
try
{
if (studID.Text != "" && kontras.Text != "" && dalykID.Text != "")
{
if (Convert.ToInt32(kontras.Text) >= 1 && Convert.ToInt32(kontras.Text) <= 10)
{
using (SqlConnection sqlCon = new SqlConnection(con))
{
sqlCon.Open();
studijuojamasdalykas ivertinimas = new studijuojamasdalykas();
ivertinimas.SDkontras = Convert.ToInt32(kontras.Text);
ivertinimas.SDstudentoID = Convert.ToInt32(studID.Text);
ivertinimas.SDdalykoID = Convert.ToInt32(dalykID.Text);
//if () {
//pavadinimas.pavadinimas = Agrupe.Text.Trim();
studijuojamasdalykas register = repos.Insertkontras(ivertinimas);
}
Clear();
}
else
{
MessageBox.Show("netinka pazymys");
}
}
else
{
MessageBox.Show("iveskite id");
}
void Clear()
{
studID.Text = kontras.Text = dalykID.Text = "";
}
showstudijuojamasdalykas();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
//iveda egza
private void ivestiegza_Click(object sender, EventArgs e)
{
try
{
if (EstudID.Text != "" && egzas.Text != "" && EdalykID.Text != "")
{
if (Convert.ToInt32(egzas.Text) >= 0 && Convert.ToInt32(egzas.Text) <= 10)
{
using (SqlConnection sqlCon = new SqlConnection(con))
{
sqlCon.Open();
studijuojamasdalykas ivertinimas = new studijuojamasdalykas();
ivertinimas.SDegzas = Convert.ToInt32(egzas.Text);
ivertinimas.SDstudentoID = Convert.ToInt32(EstudID.Text);
ivertinimas.SDdalykoID = Convert.ToInt32(EdalykID.Text);
studijuojamasdalykas register = repos.Insertegzas(ivertinimas);
}
Clear();
}
else
{
MessageBox.Show("netinka pazymys");
}
}
else
{
MessageBox.Show("iveskite id");
}
void Clear()
{
EstudID.Text = egzas.Text = EdalykID.Text = "";
}
showstudijuojamasdalykas();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}