///<summary>
///adding a new Colume to the end of the row
///</summary>
///<param name="col">adding a new colume to the end of the row</params>
///<returns>returns true of false if the colume exsist</returns>
private bool ExistColume(Col col)
{
foreach (Col colume in Columes)
{
if (colume.GetField() == col.GetField())
{
return(true);
}
}
return(false);
}
/// <summary>
/// update a Colume in row
/// </summary>
/// <param name="Col">column to update colume with new value (fields must be idintical)</param>
public void UpdateColume(Col New_data)
{
foreach (Col col in Columes)
{
if (col.GetField() == New_data.GetField())
{
col.Set(New_data);
break;
}
}
}
private static string SQL_Syntax(Col value)
{
return($"{value.GetField()} = {value.Value_SQL_Syntax()}");
}
/// <summary>
/// Copy column data from another column
/// </summary>
/// <param name="col">column to cope from</param>
public void Set(Col col)
{
_field = col.GetField();
_value = col.GetValue();
}