protected void Button11_Click(object sender, EventArgs e) { //prida do ActionCategory DatabaseLibrary.ActionCategory actCat = new DatabaseLibrary.ActionCategory(); actCat.action_id = Convert.ToInt32(DropDownList_actionCategory_action_id.SelectedValue); actCat.category_id = Convert.ToInt32(DropDownList_actionCategory_category_id.SelectedValue); new DatabaseLibrary.ActionCategoryTable().InsertActionCategory(actCat); Response.Redirect(Request.RawUrl); }
public void InsertActionCategory(ActionCategory actcat) { using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); MySqlCommand command = new MySqlCommand(INSERT, conn); /* Add parameters into the command */ command.Parameters.AddWithValue("@action_id", actcat.action_id); command.Parameters.AddWithValue("@category_id", actcat.category_id); /* Executes the command */ command.ExecuteNonQuery(); } }
public List<ActionCategory> SelectAll() { List<ActionCategory> catList = new List<ActionCategory>(); using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); MySqlCommand command = new MySqlCommand(SELECT_ALL, conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ActionCategory actcat = new ActionCategory(); actcat.action_id = reader.GetInt32(0); actcat.category_id = reader.GetInt32(1); catList.Add(actcat); } } return catList; }
public ActionCategory SelectOne(int ActionCategoryId) { ActionCategory actcat = new ActionCategory(); using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); MySqlCommand command = new MySqlCommand(SELECT_ONE, conn); command.Parameters.AddWithValue("@actioncategory_id", ActionCategoryId); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { actcat.action_id = reader.GetInt32(0); actcat.category_id = reader.GetInt32(1); } reader.Close(); } return actcat; }