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); } }