/// <remarks>Represents the foreign key object</remarks>
//private tblSolution _SolutionID_tblSolution;
//[Description("Represents the foreign key object of the type SolutionID")]
//public tblSolution m_SolutionID_tblSolution
//{
// get
// {
// return _SolutionID_tblSolution;
// }
// set
// {
// _SolutionID_tblSolution = value;
// }
//}
public override bool Load()
{
bool ret = true;
List <long> idlist = new List <long>();
//SQLiteConnection _SqlConnectionConnection = new SQLiteConnection(Common.ConnectionString);
if (Common.Conn == null)
{
Common.Conn = new SQLiteConnection(Common.ConnectionString);
Common.Conn.Open();
}
SQLiteDataReader myReader = null;
SQLiteCommand myCommand = new SQLiteCommand();
//if (_SqlConnectionConnection.State == System.Data.ConnectionState.Open)
// _SqlConnectionConnection.Close();
//_SqlConnectionConnection.ConnectionString = Common.ConnectionString;
//_SqlConnectionConnection.Open();
try
{
myReader = null;
myCommand.CommandText = @"SELECT * FROM [tblBoardtypes] ;";
myCommand.Connection = Common.Conn;
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
idlist.Add(myReader.GetInt64(myReader.GetOrdinal("BoardTypeNameID")));
}
myReader.Close();
myCommand.Dispose();
//_SqlConnectionConnection.Close();
int count = idlist.Count;
foreach (long id in idlist)// (int i = 0; i < count ; i++)
{
tblBoardType tblboardtype = new tblBoardType();
tblboardtype.BoardTypeNameID = id;// idlist[i];
tblboardtype.m_SolutionID_tblSolution = this.m_SolutionID_tblSolution;
tblboardtype.Select();
this.Add(tblboardtype);
}
//"SELECT [FunctionName], [Description], [Type], [IsStandard], [FunctionGroup], [Extensible], [IsFunction], [Body], [Language] FROM [tblFunction] WHERE [FunctionID]=@FunctionID ";
}
catch (SQLiteException ae)
{
System.Windows.Forms.MessageBox.Show(ae.Message);
return(false);
}
return(ret);
}
public bool Contains(tblBoardType item)
{
return(List.Contains(item));
}
public int IndexOf(tblBoardType item)
{
return(List.IndexOf(item));
}
public void Insert(int index, tblBoardType item)
{
List.Insert(index, item);
this.OntblBoardTypeChanged(EventArgs.Empty);
}
public void Remove(tblBoardType item)
{
List.Remove(item);
this.OntblBoardTypeChanged(EventArgs.Empty);
}
public void Add(tblBoardType item)
{
List.Add(item);
this.OntblBoardTypeChanged(EventArgs.Empty);
}
