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