Notes

// Helper method to extract field value from <input> tag
private string GetInputValue(string field)
{
// Check if the field contains an input tag
int inputStartIndex = field.IndexOf("<input");
if (inputStartIndex >= 0)
{
// Find the value attribute within the input tag
int valueStartIndex = field.IndexOf("value=", inputStartIndex);
if (valueStartIndex >= 0)
{
// Extract the attribute value
int valueStartQuoteIndex = field.IndexOf('"', valueStartIndex) + 1;
int valueEndQuoteIndex = field.IndexOf('"', valueStartQuoteIndex);
if (valueStartQuoteIndex > 0 && valueEndQuoteIndex > valueStartQuoteIndex)
{
return field.Substring(valueStartQuoteIndex, valueEndQuoteIndex - valueStartQuoteIndex);
}
}
}

return string.Empty;
}


protected void FnFormSubmit(Personal_Detail model, string hiddenRowsData)
{
try
{
// Decode HTML-encoded characters
hiddenRowsData = System.Net.WebUtility.HtmlDecode(hiddenRowsData);

// Split the hidden data into individual rows
string[] rows = hiddenRowsData.Split(new[] { "</tr>" }, StringSplitOptions.RemoveEmptyEntries);

foreach (var row in rows)
{
try
{
// Split the row into individual fields
string[] fields = row.Split(new[] { "</td>" }, StringSplitOptions.RemoveEmptyEntries);
if (fields.Length < 7) // Ensure all fields are present
{
continue;
}

// Extract individual field values excluding the last field (remove input)
string expType = GetFieldValue(fields[0]);
string orgName = GetFieldValue(fields[1]);
string designation = GetFieldValue(fields[2]);
string fromDate = GetFieldValue(fields[3]);
string toDate = GetFieldValue(fields[4]);
string description = GetFieldValue(fields[5]);
int duration;
if (!int.TryParse(GetFieldValue(fields[6]), out duration))
{
// Handle invalid duration
continue;
}

// Call your stored procedure to save the data to the database
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("[insert_KH004_Work_Exp]", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@App_no", App_no);
cmd.Parameters.AddWithValue("@expType", expType);
cmd.Parameters.AddWithValue("@orgName", orgName);
cmd.Parameters.AddWithValue("@designation", designation);
cmd.Parameters.AddWithValue("@fromDate", fromDate);
cmd.Parameters.AddWithValue("@toDate", toDate);
cmd.Parameters.AddWithValue("@description", description);
cmd.Parameters.AddWithValue("@duration", duration);
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
// Log or handle individual row processing error
// For example:
// LogError(ex);
// ShowErrorMessage("An error occurred while processing a row. Please try again later.");
}
}
}
catch (Exception ex)
{
// Handle any exceptions here
// For example:
// LogError(ex);
// ShowErrorMessage("An error occurred while processing the hidden data. Please try again later.");
}
}

// Helper method to extract field value from <td> tag
private string GetFieldValue(string field)
{
// Extract value between <td> and </td> tags
int start = field.IndexOf(">") + 1;
int end = field.LastIndexOf("<");
return field.Substring(start, end - start).Trim();
}