public void updateEvent(FinalProject.Data.Event e)
{
try
{
clsDatabase.OpenConnection();
String sql = "UPDATE event SET eventstart=@start, eventend=@end, title=@title, color=@color WHERE id=@id";
SqlCommand com = new SqlCommand(sql, clsDatabase.con);
SqlParameter p1 = new SqlParameter("@id", SqlDbType.Int);
p1.Value = e.id;
SqlParameter p2 = new SqlParameter("@title", SqlDbType.NVarChar);
p2.Value = e.title;
SqlParameter p3 = new SqlParameter("@start", SqlDbType.DateTime);
p3.Value = e.start;
SqlParameter p4 = new SqlParameter("@end", SqlDbType.DateTime);
p4.Value = e.end;
SqlParameter p5 = new SqlParameter("@des", SqlDbType.NVarChar);
p5.Value = e.description;
SqlParameter p6 = new SqlParameter("@color", SqlDbType.NVarChar);
p6.Value = e.color;
com.Parameters.Add(p1);
com.Parameters.Add(p2);
com.Parameters.Add(p3);
com.Parameters.Add(p4);
com.Parameters.Add(p5);
com.Parameters.Add(p6);
com.ExecuteNonQuery();
clsDatabase.CloseConnection();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
public void createEvent(FinalProject.Data.Event e)
{
try
{
clsDatabase.OpenConnection();
String sql = "INSERT INTO event(userid, title, eventstart, eventend, description, color)" +
"VALUES(@userid, @title, @start, @end, @des, @color)";
SqlCommand com = new SqlCommand(sql, clsDatabase.con);
SqlParameter p1 = new SqlParameter("@userid", SqlDbType.Int);
p1.Value = e.userid;
SqlParameter p2 = new SqlParameter("@title", SqlDbType.NVarChar);
p2.Value = e.title;
SqlParameter p3 = new SqlParameter("@start", SqlDbType.DateTime);
p3.Value = e.start;
SqlParameter p4 = new SqlParameter("@end", SqlDbType.DateTime);
p4.Value = e.end;
SqlParameter p5 = new SqlParameter("@des", SqlDbType.NVarChar);
p5.Value = e.description;
SqlParameter p6 = new SqlParameter("@color", SqlDbType.NVarChar);
p6.Value = e.color;
com.Parameters.Add(p1);
com.Parameters.Add(p2);
com.Parameters.Add(p3);
com.Parameters.Add(p4);
com.Parameters.Add(p5);
com.Parameters.Add(p6);
com.ExecuteNonQuery();
clsDatabase.CloseConnection();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
