//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); }