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