/// <summary>
/// This method is called when user changed the selection in the drop down
/// </summary>
/// <param name="sender">This will contains sender information</param>
/// <param name="e">This will contain evnt argument information</param>
protected void Hppfield_list_SelectedIndexChanged(object sender, EventArgs e)
{
if (hppfield_list.SelectedIndex != 0)
{
Hashtable hppFieldsHashtable = new Hashtable();
hppFieldsHashtable["hpp_id"] = hppfield_list.SelectedValue.ToString();
HppFields objHppFields = new HppFields();
DataTable dthppFields = objHppFields.GetHppFields(hppFieldsHashtable);
foreach (DataRow hppFieldRow in dthppFields.Rows)
{
field_id.Text = hppFieldRow["hpp_id"].ToString();
filed_name.Text = hppFieldRow["hpp_field_name"].ToString();
filed_description.Text = hppFieldRow["hpp_field_desc"].ToString();
if (hppFieldRow["hppfield_mapped"].ToString() == "0")
{
filed_name.Enabled = true;
filed_description.Enabled = true;
save.Enabled = true;
}
else
{
filed_name.Enabled = false;
filed_description.Enabled = false;
save.Enabled = false;
}
}
hppFieldsHashtable.Clear();
}
else
{
// get identity value
Hashtable hppFieldshashtable = new Hashtable();
hppFieldshashtable["identity_value"] = 1;
HppFields objHppFields = new HppFields();
fieldID = objHppFields.GetHppFields(hppFieldshashtable).Rows[0][0].ToString();
field_id.Text = fieldID;
filed_name.Text = string.Empty;
filed_description.Text = string.Empty;
filed_name.Enabled = true;
filed_description.Enabled = true;
save.Enabled = true;
}
lb_fieldname_error_invalid.Visible = false;
lb_field_error.Visible = false;
}
/// <summary>
/// This method will load all the hppfields information from the database.
/// </summary>
protected void LoadHppFields()
{
hppfield_list.Items.Clear();
Hashtable hppFieldsHashtable = new Hashtable();
HppFields objHppFields = new HppFields();
DataTable dthppFields = objHppFields.GetHppFields(hppFieldsHashtable);
hppfield_list.DataSource = dthppFields;
hppfield_list.DataTextField = "hpp_field";
hppfield_list.DataValueField = "hpp_id";
DataRow addingRow;
addingRow = dthppFields.NewRow();
addingRow["hpp_id"] = 0;
addingRow["hpp_field"] = "-- New --";
dthppFields.Rows.InsertAt(addingRow, 0);
hppfield_list.DataBind();
// get identity value.
dthppFields.Clear();
hppFieldsHashtable.Clear();
hppFieldsHashtable["identity_value"] = 1;
fieldID = objHppFields.GetHppFields(hppFieldsHashtable).Rows[0][0].ToString();
field_id.Text = fieldID;
filed_name.Text = string.Empty;
filed_description.Text = string.Empty;
}
/// <summary>
/// Save_click will insert the records into the database.
/// </summary>
/// <param name="sender">This contains sender information</param>
/// <param name="e">This contain event argement information</param>
protected void Save_Click(object sender, EventArgs e)
{
try
{
if (hppfield_list.SelectedIndex == 0)
{
if (string.IsNullOrEmpty(filed_name.Text))
{
lb_fieldname_error_invalid.Visible = true;
}
else
{
Hashtable hppFieldshashtable = new Hashtable();
hppFieldshashtable["hpp_field_name"] = filed_name.Text;
hppFieldshashtable["hpp_field_desc"] = filed_description.Text;
HppFields objHppFields = new HppFields();
objHppFields.CreateHppFields(hppFieldshashtable);
this.LoadHppFields();
lb_fieldname_error_invalid.Visible = false;
}
}
else
{
Hashtable hppFieldshasthtable = new Hashtable();
hppFieldshasthtable["hpp_field_name"] = filed_name.Text;
hppFieldshasthtable["hpp_field_desc"] = filed_description.Text;
hppFieldshasthtable["hpp_id"] = hppfield_list.SelectedValue.ToString();
HppFields objHppFields = new HppFields();
objHppFields.UpdateHppFields(hppFieldshasthtable);
this.LoadHppFields();
}
lb_field_error.Visible = false;
}
catch (SqlException exc)
{
if (exc.Message.Contains("UNIQUE KEY constraint"))
{
lb_field_error.Visible = true;
}
else
{
throw;
}
}
}
