protected void lbtnEditSave_Click(object sender, EventArgs e)
{
try
{
if (hdnfield.Value != "")
{
string CustomField = string.Empty;
bool IsSuccess = false;
int fieldId = Convert.ToInt32(hdnfield.Value);
AdvanceManageFieldBase objManageFields = new AdvanceManageFieldBase(ConnectionString);
objManageFields.FieldId = fieldId;
objManageFields.FieldName = txtEditFieldName.Text;
objManageFields.FieldType = DropDownList1.SelectedValue.ToString();
if (txtEditMaxLen.Text != "")
objManageFields.MaxLength = Convert.ToInt32(txtEditMaxLen.Text);
if (DropDownList1.SelectedItem.Value == "Text Box")
objManageFields.DefaultValue = txtEditDefaultValue.Text;
if (DropDownList1.SelectedItem.Value == "Check Box")
objManageFields.DefaultValue = chkEditDefault.Checked.ToString();
if (DropDownList1.SelectedItem.Value == "Date")
objManageFields.DefaultValue = txtEditDate.Text;
if (txtEditDispPos.Text != "")
objManageFields.DisplayPosition = Convert.ToInt32(txtEditDispPos.Text);
objManageFields.PrimaryField = chkEditPrimaryField.Checked;
objManageFields.RequiredField = chkEditReqField.Checked;
objManageFields.PersonalizedField = chkEditPersonalizedField.Checked;
objManageFields.Reserved = false;
IsSuccess = objManageFields.Update(ConnectionString);
if (DropDownList1.SelectedItem.Value == "Drop Down List" || DropDownList1.SelectedItem.Value == "Radio Button List")
{
DataTable dtFields = new DataTable("ManageFieldsProperty");
dtFields.Columns.Add("Item"); //or something similar
dtFields.Columns.Add("value");
dtFields.Columns.Add("FieldId");
for (int i = 0; i < Gridview2.Rows.Count; ++i)
{
DataRow dr = dtFields.NewRow();
TextBox box2 = (TextBox)Gridview2.Rows[i].Cells[0].FindControl("TextBox1");
TextBox box3 = (TextBox)Gridview2.Rows[i].Cells[0].FindControl("TextBox2");
dr["Item"] = box2.Text;
dr["value"] = box3.Text;
dr["FieldId"] = fieldId;
dtFields.Rows.Add(dr);
}
//removing all fields before updating values
AdvanceManageFieldsPropertyBase objMFProp = new AdvanceManageFieldsPropertyBase(ConnectionString);
objMFProp.Item = "FieldId";
objMFProp.Value = fieldId.ToString();
IsSuccess = objMFProp.Delete(ConnectionString);
DatabaseHelperExtension odbseHelper = new DatabaseHelperExtension(ConnectionString);
odbseHelper.AddColumn("Item", "Item");
odbseHelper.AddColumn("value", "value");
odbseHelper.AddColumn("FieldId", "FieldId");
odbseHelper.ExcuteSQLBulkCopy(dtFields, "AdvanceManageFieldsProperty", ref IsSuccess);
}
lblmsg.Style.Add("color", "green");
lblmsg.Text = txtEditFieldName.Text + " updated successfully";
bindGrid("");
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Populates the fields of a single objects from the columns found in an open reader.
/// </summary>
/// <param name="obj" type="AdvanceManageFieldsProperty">Object of AdvanceManageFieldsProperty to populate</param>
/// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 8/29/2012 03:30:46 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static void PopulateObjectFromReader(AdvanceManageFieldsPropertyBase obj,IDataReader rdr)
{
obj.ManageFieldPropertyID = rdr.GetInt64(rdr.GetOrdinal(AdvanceManageFieldsPropertyFields.ManageFieldPropertyID));
obj.FieldId = rdr.GetInt64(rdr.GetOrdinal(AdvanceManageFieldsPropertyFields.FieldId));
obj.Item = rdr.GetString(rdr.GetOrdinal(AdvanceManageFieldsPropertyFields.Item));
obj.Value = rdr.GetString(rdr.GetOrdinal(AdvanceManageFieldsPropertyFields.Value));
}