public void Insertmasterclass(Masterclass masterclass)
{
try
{
conn.Open();
string insertString = @"INSERT INTO masterclass (e_code, minimale_rating, bekende_speler)
VALUES (@e_code, @minimale_rating, @bekende_speler)";
MySqlCommand cmd = new MySqlCommand(insertString, conn);
MySqlParameter ECodeParam = new MySqlParameter("@e_code", MySqlDbType.Int32);
MySqlParameter MinRatingParam = new MySqlParameter("@minimale_rating", MySqlDbType.Int32);
MySqlParameter BekendeSpelerParam = new MySqlParameter("@bekende_speler", MySqlDbType.Int32);
ECodeParam.Value = masterclass.E_code;
MinRatingParam.Value = masterclass.Minimale_rating;
BekendeSpelerParam.Value = masterclass.Bekende_Speler.P_Code;
cmd.Parameters.Add(ECodeParam);
cmd.Parameters.Add(MinRatingParam);
cmd.Parameters.Add(BekendeSpelerParam);
cmd.Prepare();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine("Masterclass niet toegeveogd: " + ex);
}
finally
{
conn.Close();
}
}
public void Updatemasterclass(Masterclass masterclass)
{
try
{
conn.Open();
string insertString = @"UPDATE masterclass SET minimale_rating = @minimale_rating,
bekende_speler = @bekende_speler where e_code = @e_code";
MySqlCommand cmd = new MySqlCommand(insertString, conn);
MySqlParameter ECodeParam = new MySqlParameter("@e_code", MySqlDbType.Int32);
MySqlParameter MinRatingParam = new MySqlParameter("@minimale_rating", MySqlDbType.Int32);
MySqlParameter BekendeSpelerParam = new MySqlParameter("@bekende_speler", MySqlDbType.Int32);
ECodeParam.Value = masterclass.E_code;
MinRatingParam.Value = masterclass.Minimale_rating;
BekendeSpelerParam.Value = masterclass.Bekende_Speler.P_Code;
cmd.Parameters.Add(ECodeParam);
cmd.Parameters.Add(MinRatingParam);
cmd.Parameters.Add(BekendeSpelerParam);
cmd.Prepare();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine("Masterclass niet geupdate: " + ex);
}
finally
{
conn.Close();
}
}
protected virtual ActionResult View(Masterclass model)
{
return(View("Details",
new ViewData.Masterclass.DetailsViewData()
{
Item = ObjectExtension.As <MasterclassViewModel.Details>(model)
}));
}
public List <Masterclass> GetMasterclasses()
{
List <Masterclass> masterclasses = new List <Masterclass>();
try
{
conn.Open();
string selectQuery = @"SELECT e_code, minimale_rating, roepnaam
FROM masterclass
left join bekende_speler on
bekende_speler = p_code
order by e_code";
MySqlCommand cmd = new MySqlCommand(selectQuery, conn);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
int EventCode = dataReader.GetInt32("e_code");
int MinRating = dataReader.GetInt32("minimale_rating");
string BekendeSpeler = dataReader.GetString("roepnaam");
Masterclass masterclass = new Masterclass();
masterclass.E_code = EventCode;
masterclass.Bekende_Speler.Roepnaam = BekendeSpeler;
masterclass.Minimale_rating = MinRating;
EventController events = new EventController();
LocatieController locaties = new LocatieController();
foreach (Event val in events.GetEvents())
{
if (EventCode == val.E_code)
{
masterclass.Datum = val.Datum;
masterclass.L_code = val.L_code;
break;
}
}
foreach (Locatie val in locaties.GetLocaties())
{
if (masterclass.L_code == val.L_code)
{
masterclass.Locatie.Straat = val.Straat;
}
}
masterclasses.Add(masterclass);
}
}
catch (Exception ex)
{
Console.WriteLine("Ophalen van Masterclass mislukt" + ex);
}
finally
{
conn.Close();
}
return(masterclasses);
}
private void UpdateMasterclass()
{
Masterclass temp_masterclass = new Masterclass();
temp_masterclass.Minimale_rating = int.Parse(TxtUpdateRating.Text);
temp_masterclass.Bekende_Speler.P_Code = BekendeSpelerDB.GetPCode(CBUpdateSpeler.Text);
temp_masterclass.E_code = int.Parse(TxtUpdateEcode.Text);
MasterDB.Updatemasterclass(temp_masterclass);
}
public ActionResult Edit(string shortcut)
{
if (shortcut == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Masterclass masterclass = _context.Masterclasses.SingleOrDefault(x => x.Shortcut == shortcut);
if (masterclass == null)
{
return(HttpNotFound());
}
return(View(masterclass.As <MasterclassEditModel>()));
}
private void MakeMasterclass(int Temp_Ecode)
{
Masterclass temp_masterclass = new Masterclass();
temp_masterclass.Bekende_Speler.P_Code = BekendeSpelerDB.GetPCode(CBAdd.Text);
temp_masterclass.E_code = Temp_Ecode;
if (string.IsNullOrEmpty(TxtRating.Text) && CBAdd.SelectedItem == null || CBLocatie.SelectedItem == null)
{
MessageBox.Show("Niet alle velden zijn ingevuld.");
BSubmit.DialogResult = DialogResult.None;
}
else
{
temp_masterclass.Minimale_rating = int.Parse(TxtRating.Text);
BSubmit.DialogResult = DialogResult.OK;
}
MasterDB.Insertmasterclass(temp_masterclass);
}
