public static void update_ActivityFeedback_Recieve_Student_In_DB(ActivityFeedback af) { if (af.getRecieveStudent() != null) { SqlCommand c = new SqlCommand(); c.CommandText = "EXECUTE dbo.SP_add_ActivityFeedback_Recieve_Student @RecieveStudent, @Id"; c.Parameters.AddWithValue("@RecieveStudent", af.getRecieveStudent().getId()); c.Parameters.AddWithValue("@Id", af.getId()); SQL_CON SC = new SQL_CON(); SC.execute_non_query(c); } }
public static void create_ActivityFeedback_In_DB(ActivityFeedback af) { SqlCommand c = new SqlCommand(); c.CommandText = "EXECUTE dbo.SP_add_ActivityFeedback1 @Id, @Dt, @Description, @Creator"; c.Parameters.AddWithValue("@id", af.getId()); c.Parameters.AddWithValue("@Dt", af.getDateTime()); c.Parameters.AddWithValue("@Description", af.getDescription()); if (af.getCreator() != null) { c.Parameters.AddWithValue("@Creator", af.getCreator().getId()); } SQL_CON SC = new SQL_CON(); SC.execute_non_query(c); }