public void EditCoScholastic(mst_co_scholastic mst) { try { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { mst_sessionMain session = new mst_sessionMain(); mst.session = session.findFinal_Session(); string query = @"UPDATE mst_co_scholastic SET co_scholastic_name = @co_scholastic_name WHERE co_scholastic_id = @co_scholastic_id AND session = @session"; con.Execute(query, mst); } } catch (Exception ex) { throw ex; } }
public void AddCoScholastic(mst_co_scholastic mst) { try { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { string query = "INSERT INTO mst_co_scholastic (session,co_scholastic_id,co_scholastic_name) VALUES (@session,@co_scholastic_id,@co_scholastic_name)"; string maxid = @"SELECT IFNULL(MAX(co_scholastic_id), 0) + 1 FROM mst_co_scholastic WHERE session = (SELECT session FROM mst_session WHERE session_finalize = 'Y')"; int id = con.ExecuteScalar <int>(maxid); mst_sessionMain session = new mst_sessionMain(); mst.session = session.findActive_finalSession(); mst.co_scholastic_id = id; mst.co_scholastic_name = mst.co_scholastic_name.Trim(); con.Execute(query, new { mst.co_scholastic_id, mst.co_scholastic_name, mst.session }); } } catch (Exception ex) { throw ex; } }