/// <summary> /// Updates the field. /// </summary> /// <param name="field">The field.</param> public static void UpdateField(Field field) { if (field == null || field.Id < 1) throw new CustomException("Invalid field of knowledge argument","Can`t update this value"); Field.Update(field); Context.SaveChanges(); }
/// <summary> /// Deletes the field. /// </summary> /// <param name="field">The field.</param> public static void DeleteField(Field field) { if (field==null||field.Id < 1) throw new CustomException("Invalid field of knowledge argument","Can`t delete field"); Field.Delete(field); Context.SaveChanges(); }
/// <summary> /// Adds the field. /// </summary> /// <param name="field">The field.</param> public static void AddField(Field field) { if (field==null||string.IsNullOrEmpty(field.Title)) throw new CustomException("Invalid field of knowledge argument","Can`t add this value"); Field.Add(field); Context.SaveChanges(); }
public static FieldViewModel Convert(Field field) { var name = field.Name; var viewModel = new FieldViewModel(name); viewModel.Id = field.Id; viewModel.SelectedAngle.DataValue = field.Angle; viewModel.Description.DataValue = field.Description; viewModel.IsActive.DataValue = field.IsActive; viewModel.IsRequired.DataValue = field.IsRequired; viewModel.Mask.DataValue = field.Mask; viewModel.FixedValue.DataValue = field.FixedValue; viewModel.ValidChars.DataValue = field.ValidChars; viewModel.SelectedFieldType.DataValue = field.FieldType; return viewModel; }
private void GetColumns(Table table) { Dictionary <string, string> dictionary = new Dictionary <string, string>(); DataRowCollection rows = this.helper.ExecuteDataset(CommandType.Text, "select * from SYSCAT.COLUMNS where TABNAME='" + table + "' ORDER BY COLNO", null).Tables[0].Rows; foreach (DataRow row2 in rows) { Model.Field fieldex = new Model.Field(); fieldex.Name = row2["COLNAME"].ToString(); fieldex.FieldType = SchemaHelper.GetString(row2["TYPENAME"]); if (dictionary.ContainsKey(fieldex.Name)) { fieldex.IsKey = true; } else { fieldex.IsKey = false; } if (row2["NULLS"].ToString() == "N") { fieldex.AllowNull = false; } else { fieldex.AllowNull = true; } if (row2["IDENTITY"].ToString() == "Y") { fieldex.IsId = true; } else { fieldex.IsId = false; } fieldex.Pos = Convert.ToInt32(row2["COLNO"]); fieldex.Length = Convert.ToInt32(row2["LENGTH"]); fieldex.DefaultValue = row2["DEFAULT"].ToString(); fieldex.Descn = fieldex.Name; table.AddField(fieldex); } }
private void GetColumns(Table table) { DataTable schema; using (SQLiteConnection connection = new SQLiteConnection(helper.ConnectionString)) { connection.Open(); schema = connection.GetSchema("COLUMNS"); } foreach (DataRow r in schema.Select(string.Format("TABLE_NAME = '{0}'", table))) { Model.Field model = new Model.Field(); model.AllowNull = Convert.ToBoolean(r["IS_NULLABLE"]); model.Position = Convert.ToInt32(r["ORDINAL_POSITION"]); model.Name = r["COLUMN_NAME"].ToString(); model.SetDbType(Model.DatabaseTypes.SQLite, SchemaHelper.GetString(r["DATA_TYPE"])); model.DefaultValue = r["COLUMN_DEFAULT"].ToString(); model.Descn = SchemaHelper.GetString(r["DESCRIPTION"]); model.Size = Convert.ToInt32((r["CHARACTER_MAXIMUM_LENGTH"] == DBNull.Value) ? 0 : r["CHARACTER_MAXIMUM_LENGTH"]); model.Length = SchemaHelper.GetInt(r["CHARACTER_MAXIMUM_LENGTH"]); model.IsIdentifier = SchemaHelper.GetBool(r["AUTOINCREMENT"]); if (Convert.ToBoolean(r["PRIMARY_KEY"])) { model.IsKeyField = true; } else { model.IsKeyField = false; } table.AddField(model); } }
public Cart(Field initialField) { this.Spot = initialField; _toChar = 'W'; }