private void Botton_Add_SesInfo_Click(object sender, EventArgs e)
{
BookingAppContext bc = new BookingAppContext();
Gymsession g = new Gymsession();
g.gid = TextB_SesID_SesInfo.Text;
g.gtitle = TextB_Title_SesInfo.Text;
g.gdate = Date_Time_Date_SesInfo.Text;
g.gmax_spots = TextB_Spots_SesInfo.Text;
g.ginstructor = TextB_Instructor_SesInfo.Text;
try
{
bc.Gymsessions.Add(g);
bc.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Varning det blev fel");
}
/*
* string cs = null;
* SqlConnection cnn = new SqlConnection(cs);
* SqlCommand cmd;
* string sql = null;
*
* cs = "Data Source=LAPTOP-SCJU4H3Q;Initial Catalog=hatoca-inlamning;Integrated Security= SSPI;User ID=hatoca;Password=hatoca123;";
*
* try
* {
* cnn.Open();
* cmd = new SqlCommand(sql, cnn);
* cmd.ExecuteNonQuery();
* cmd.Dispose();
* cnn.Close();
* MessageBox.Show("ExecuteNonQuery in SqlCommand executed!!");
* }
* catch (Exception ex)
* {
* MessageBox.Show("Could not open SqlConnection!");*/
}
public void InitializeTypes()
{
if (_context.EventTypes.Any())
{
return;
}
_context.EventTypes.AddRange(
new EventType
{
Type = "Football Match"
},
new EventType
{
Type = "Basketball Match"
},
new EventType
{
Type = "Concert"
},
new EventType
{
Type = "Party"
},
new EventType
{
Type = "Art"
},
new EventType
{
Type = "Convention"
}
);
_context.SaveChanges();
}
public void Add(Business data)
{
_context.Businesses.Add(data);
_context.SaveChanges();
}
public void Add(Schedule data)
{
_context.Schedules.Add(data);
_context.SaveChanges();
}
public void Add(User data)
{
_context.Users.Add(data);
_context.SaveChanges();
}
public void Add(Reservation data)
{
_context.Reservations.Add(data);
_context.SaveChanges();
}