//private List<Field> LoadPanelContent(SqlConnection con, int CompanyID, string LanguageID)
//{
// List<TempMultiSelectItem> AllMultiSelectItem = new List<TempMultiSelectItem>();
// List<Field> ret = new List<Field>();
// SqlCommand sql = new SqlCommand("GetPanelFields", con);
// sql.CommandType = CommandType.StoredProcedure;
// sql.Parameters.Add(new SqlParameter("PanelID", this.id));
// sql.Parameters.Add(new SqlParameter("CompanyID", CompanyID));
// sql.Parameters.Add(new SqlParameter("LanguageID", LanguageID));
// try
// {
// using (SqlDataReader sdr = sql.ExecuteReader())
// {
// while (sdr.Read())
// {
// Field f = null;
// int? FieldID = sdr.IsDBNull(0) ? (int?)null : sdr.GetInt32(0);
// string FieldType = sdr.GetString(1).Trim();
// string Label = sdr.GetString(2).Trim();
// string StringValue = (sdr.IsDBNull(3) ? "" : sdr.GetString(3).Trim());
// switch (FieldType)
// {
// case "tx":
// f = new LabelTextBoxField((int)FieldID, Label, StringValue);
// break;
// case "rb":
// f = new LabelRBCBControl<LabelRadioButtonField>(FieldID.ToString(), Label);
// ((LabelRBCBControl<LabelRadioButtonField>)f).OtherRef = (sdr.IsDBNull(7) ? -1 : sdr.GetInt32(7));
// ((LabelRBCBControl<LabelRadioButtonField>)f).SelectedValues = StringValue.Split(',');
// break;
// case "cb":
// f = new LabelRBCBControl<LabelCheckBoxField>(FieldID.ToString(), Label);
// ((LabelRBCBControl<LabelCheckBoxField>)f).OtherRef = (sdr.IsDBNull(7) ? -1 : sdr.GetInt32(7));
// ((LabelRBCBControl<LabelCheckBoxField>)f).SelectedValues = StringValue.Split(',');
// break;
// case "rb-item":
// case "cb-item":
// TempMultiSelectItem tmsi = new TempMultiSelectItem();
// tmsi.StringValue = (sdr.IsDBNull(3) ? "" : sdr.GetString(3).Trim());
// tmsi.OtherRef = sdr.GetInt32(7);
// tmsi.MultiSelectItemID = sdr.GetInt32(8);
// AllMultiSelectItem.Add(tmsi);
// break;
// default:
// break;
// }
// if (f != null)
// ret.Add(f);
// }
// }
// }
// catch (Exception eee)
// {
// ret.Add(new LabelTextAreaField(1,"Exception in LoadPanelContent(..)",eee.ToString()));
// }
// AssignMultiSelectItemsToControls();
// return ret;
//}
public string GetSaveSQL(IFormCollection fc, FieldValueUpdateInfo UpdateInfo)
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < Fields.Count; i++)
{
List <Field> DBFields = Fields[i].GetDBFields();
for (int f = 0; f < DBFields.Count; f++)
{
string UpdateString = null;
StringValues NewValue = new StringValues();
if (fc.TryGetValue(DBFields[f].HTMLFieldID, out NewValue))
{
UpdateString = DBFields[f].CreateDBUpdateStringIfNecessary(NewValue, UpdateInfo);
}
else
{
UpdateString = DBFields[f].GetResetDBUpdateString(UpdateInfo); // Update DB value to default val.
}
if (UpdateString != null)
{
sb.AppendLine(UpdateString);
}
}
}
return(sb.ToString());
}
public static int RunSQLQuery(FieldValueUpdateInfo UpdateInfo, string sql)
{
try
{
UpdateInfo.con.Open();
using (SqlCommand cmd = new SqlCommand(sql, UpdateInfo.con))
{
int rows = cmd.ExecuteNonQuery();
return(rows);
}
}
catch (Exception e)
{
Console.Out.WriteLine(e.ToString());
}
finally
{
UpdateInfo.con.Close();
}
return(-1);
}
