//update a type
public static bool UpdateType(RiskType type)
{
MySqlParameter[] parms = new MySqlParameter[] {
new MySqlParameter(PARAM_TYPENUMBER, type.TypeNumber),
new MySqlParameter(PARAM_TYPENAME, type.TypeName)};
return MySqlHelper.ExecuteNonQuery(MySqlHelper.CONN_STR, CommandType.Text, UPDATE_TYPE, parms);
}
//Get type by id from database
public static bool GetTypeByNumber(String TypeNumber, out RiskType type)
{
MySqlParameter parm = new MySqlParameter(PARAM_TYPENUMBER, MySqlDbType.VarChar, 45);
parm.Value = TypeNumber;
using (MySqlDataReader sdr = MySqlHelper.ExecuteReader(MySqlHelper.CONN_STR, CommandType.Text, SELECT_TYPE_BY_TYPENAME, parm))
{
if (sdr.Read())
{
type = new RiskType(sdr.GetString(0), sdr.GetString(1));
return true;
}
else
{
type = null;
return false;
}
}
}