protected void drpParameterType_SelectedIndexChanged(object sender, EventArgs e)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@OPR", "74"),
new SqlParameter("@ParameterName", txtParameterName.Text),
new SqlParameter("@ParameterType", drpParameterType.SelectedValue),
new SqlParameter("@CreatedBy", txtCreatedBy.Text)
};
if (drpParameterType.SelectedIndex == 0)
{
param = new SqlParameter[]
{
new SqlParameter("@OPR", "74"),
new SqlParameter("@ParameterName", txtParameterName.Text),
new SqlParameter("@CreatedBy", txtCreatedBy.Text)
};
}
DataTable Dt = new DataTable();
Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_DATA");
GrdParameterList.DataSource = Dt;
GrdParameterList.DataBind();
}
protected void BtnShow_Click(object sender, EventArgs e)
{
bool parameterTypeIsNull = false;
try
{
if (string.IsNullOrEmpty(txtParameterName.Text) && drpParameterType.SelectedIndex == 0 && string.IsNullOrEmpty(txtCreatedBy.Text))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('Please select/Enter atleast one field')", true);
}
else
{
if (drpParameterType.SelectedIndex == 0)
{
parameterTypeIsNull = true;
drpParameterType.Items.RemoveAt(0);
drpParameterType.Items.Insert(0, new ListItem("0"));
drpParameterType.SelectedValue = "0";
}
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@OPR", "74"),
new SqlParameter("@ParameterName", txtParameterName.Text),
new SqlParameter("@ParameterType", drpParameterType.SelectedValue),
new SqlParameter("@CreatedBy", txtCreatedBy.Text)
};
DataTable Dt = new DataTable();
Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_DATA");
GrdParameterList.DataSource = Dt;
GrdParameterList.DataBind();
if (Dt.Rows.Count > 0)
{
if (parameterTypeIsNull)
{
drpParameterType.Items.RemoveAt(0);
drpParameterType.Items.Insert(0, new ListItem("Select Parameter Type"));
}
}
else if (Dt.Rows.Count == 0)
{
if (parameterTypeIsNull)
{
drpParameterType.Items.RemoveAt(0);
drpParameterType.Items.Insert(0, new ListItem("Select Parameter Type"));
}
}
}
}
catch (Exception ex)
{
_logger.Error(string.Concat("BindCompletedParametersGrid::", ex.Message), ex);
}
}
protected void GetData()
{
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@OPR", 22),
};
DataTable Dt = new DataTable();
Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_DATA");
GrdParameterList.DataSource = Dt;
GrdParameterList.DataBind();
}
catch (Exception ex)
{
_logger.Error(string.Concat("GetData::", ex.Message), ex);
}
}
