internal void DeleteParameter(Parameter parameter)
{
int result = 0;
using (MySqlConnection connection = new MySqlConnection(GetConnectionString()))
{
MySqlCommand cmd = new MySqlCommand("usp_DeleteParameter", connection);
cmd.CommandType = CommandType.StoredProcedure;
AddSqlParameter(cmd, "iParameterID", MySqlDbType.Int32, parameter.ParameterID);
connection.Open();
result = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
}
}
internal Parameter UpdateParameter(Parameter parameter)
{
int result = 0;
using (MySqlConnection connection = new MySqlConnection(GetConnectionString()))
{
MySqlCommand cmd = new MySqlCommand("usp_UpdateParameter", connection);
cmd.CommandType = CommandType.StoredProcedure;
AddSqlParameter(cmd, "iParameterID", MySqlDbType.Int32, parameter.ParameterID);
AddSqlParameter(cmd, "iParameterSetID", MySqlDbType.Int32, parameter.ParameterSetID);
AddSqlParameter(cmd, "iParameterName", MySqlDbType.VarChar, 4000, parameter.ParameterName);
AddSqlParameter(cmd, "iParameterValue", MySqlDbType.VarChar, 4000, parameter.ParameterValue);
connection.Open();
result = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
}
return parameter;
}
internal List<Parameter> GetParametersByParameterSetID(int parameterSetID)
{
List<Parameter> parameters = new List<Parameter>();
using (MySqlConnection connection = new MySqlConnection(GetConnectionString()))
{
MySqlDataReader dr = null;
MySqlCommand cmd = new MySqlCommand("usp_GetParametersByParameterSetID", connection);
cmd.CommandType = CommandType.StoredProcedure;
AddSqlParameter(cmd, "iParameterSetID", MySqlDbType.Int32, parameterSetID);
connection.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Parameter parameter = new Parameter();
parameter.ParameterID = (int)dr["ParameterID"];
parameter.ParameterSetID = (int)dr["ParameterSetID"];
parameter.ParameterName = dr["ParameterName"].ToString();
parameter.ParameterValue = dr["ParameterValue"].ToString();
parameters.Add(parameter);
}
cmd.Dispose();
}
return parameters;
}
private void btnSaveParameterSet_Click(object sender, EventArgs e)
{
if (IsParameterSetBlankOrDuplicate())
{
lblParamSetNameError.Visible = true;
cboParameterSetName.Focus();
}
else if (cboParameterSetName.Text.Length > 0)
{
ParameterSet parameterSet;
if (_newParameterSet)
{
parameterSet = new ParameterSet();
parameterSet.ParameterSetName = cboParameterSetName.Text;
}
else
{
parameterSet = (((ComboBoxItem)cboParameterSetName.SelectedItem).ParameterSet);
}
parameterSet.ParameterSetDescription = txtParameterSetDescription.Text;
parameterSet.ReportID = _reporterBO.SelectedReport.ReportID;
parameterSet.Parameters.Clear();
foreach (ListViewItem item in lvwParameters.Items)
{
Parameter parameter = new Parameter();
parameter.ParameterID = Convert.ToInt32(item.Tag);
parameter.ParameterName = item.Text;
parameter.ParameterValue = item.SubItems[1].Text;
parameterSet.Parameters.Add(parameter);
}
parameterSet = _reporterBO.SaveParameterSet(parameterSet);
_parameterSets = _reporterBO.AvailableParameterSets;
DisplayParameterSets();
for (int i = 0; i < cboParameterSetName.Items.Count; i++)
{
if (parameterSet.ParameterSetName == cboParameterSetName.Items[i].ToString())
{
cboParameterSetName.SelectedIndex = i;
}
}
lblParamSetNameError.Visible = false;
btnNewParameterSet.Enabled = true;
_newParameterSet = false;
}
}