private static List <Stables> EntityList(string q)
{
List <Stables> list = new List <Stables>();
using (IDataReader redr = new SQLITE_DAL().Listreader(q))
{
while (redr.Read() == true)
{
Stables obj = new Stables()
{
Stables_id = redr[STABLES.STABLES_ID].ToString(),
Stables_name = redr[STABLES.STABLES_NAME].ToString(),
Alias = redr[STABLES.ALIAS].ToString(),
Namespaces_id = redr[NAMESPACES.NAMESPACES_NAME].ToString(),
Databases_id = redr[DATABASES.DATABASES_NAME].ToString(),
Active_id = redr[STABLES.ACTIVE_ID].ToString(),
};
list.Add(obj);
}
redr.Close();
}
return(list);
}
private static Spath EntityData(string q)
{
using (IDataReader redr = new SQLITE_DAL().Listreader(q))
{
while (redr.Read() == true)
{
Spath obj = new Spath()
{
Spath_id = redr[SPATH.SPATH_ID].ToString(),
Stables_id = redr[STABLES.STABLES_NAME].ToString(),
Root_folder = redr[SPATH.ROOT_FOLDER].ToString(),
Contfolder = redr[SPATH.CONTFOLDER].ToString(),
Classfolder = redr[SPATH.CLASSFOLDER].ToString(),
Formfolder = redr[SPATH.FORMFOLDER].ToString(),
Listfolder = redr[SPATH.LISTFOLDER].ToString(),
Setupfolder = redr[SPATH.SETUPFOLDER].ToString(),
Testfolder = redr[SPATH.TESTFOLDER].ToString(),
Active_id = redr[SPATH.ACTIVE_ID].ToString(),
};
return(obj);
}
redr.Close();
return(new Spath());
}
}
private static List <MasterTablePath> EntityList(string q)
{
List <MasterTablePath> list = new List <MasterTablePath>();
using (IDataReader redr = new SQLITE_DAL().Listreader(q))
{
while (redr.Read() == true)
{
MasterTablePath obj = new MasterTablePath()
{
Masterpath_id = redr[MASTERPATH.MASTERPATH_ID].ToString(),
Mastertables_id = redr[MASTERTABLES.MASTERTABLES_NAME].ToString(),
Root_folder = redr[MASTERPATH.ROOT_FOLDER].ToString(),
Contfolder = redr[MASTERPATH.CONTFOLDER].ToString(),
Classfolder = redr[MASTERPATH.CLASSFOLDER].ToString(),
Formfolder = redr[MASTERPATH.FORMFOLDER].ToString(),
Listfolder = redr[MASTERPATH.LISTFOLDER].ToString(),
Setupfolder = redr[MASTERPATH.SETUPFOLDER].ToString(),
Testfolder = redr[MASTERPATH.TESTFOLDER].ToString(),
Active_id = redr[MASTERPATH.ACTIVE_ID].ToString(),
};
list.Add(obj);
}
redr.Close();
}
return(list);
}
private static Version EntityData(string q)
{
using (IDataReader redr = new SQLITE_DAL().Listreader(q))
{
while (redr.Read() == true)
{
Version obj = new Version()
{
Version_id = redr[VERSION.VERSION_ID].ToString(),
Version_name = redr[VERSION.VERSION_NAME].ToString(),
Created_on = redr[VERSION.CREATED_ON].ToString(),
Changes = redr[VERSION.CHANGES].ToString()
};
return(obj);
}
redr.Close();
return(new Version());
}
}
private static Namespaces EntityData(string q)
{
using (IDataReader redr = new SQLITE_DAL().Listreader(q))
{
while (redr.Read() == true)
{
Namespaces obj = new Namespaces()
{
Namespaces_id = redr[NAMESPACES.NAMESPACES_ID].ToString(),
Namespaces_name = redr[NAMESPACES.NAMESPACES_NAME].ToString(),
Notes = redr[NAMESPACES.NOTES].ToString(),
Active_id = redr[NAMESPACES.ACTIVE_ID].ToString()
};
return(obj);
}
redr.Close();
return(new Namespaces());
}
}
private static MasterTables EntityData(string q)
{
using (IDataReader redr = new SQLITE_DAL().Listreader(q))
{
while (redr.Read() == true)
{
MasterTables obj = new MasterTables()
{
Mastertables_id = redr[MASTERTABLES.MASTERTABLES_ID].ToString(),
Databases_id = redr[DATABASES.DATABASES_NAME].ToString(),
Mastertables_name = redr[MASTERTABLES.MASTERTABLES_NAME].ToString(),
Alias = redr[MASTERTABLES.ALIAS].ToString(),
Namespaces_id = redr[NAMESPACES.NAMESPACES_NAME].ToString(),
Active_id = redr[MASTERTABLES.ACTIVE_ID].ToString(),
};
return(obj);
}
redr.Close();
return(new MasterTables());
}
}
private static List <Version> EntityList(string q)
{
List <Version> list = new List <Version>();
using (IDataReader redr = new SQLITE_DAL().Listreader(q))
{
while (redr.Read() == true)
{
Version obj = new Version()
{
Version_id = redr[VERSION.VERSION_ID].ToString(),
Version_name = redr[VERSION.VERSION_NAME].ToString(),
Created_on = redr[VERSION.CREATED_ON].ToString(),
Changes = redr[VERSION.CHANGES].ToString()
};
list.Add(obj);
}
redr.Close();
}
return(list);
}
private static List <Namespaces> EntityList(string q)
{
List <Namespaces> list = new List <Namespaces>();
using (IDataReader redr = new SQLITE_DAL().Listreader(q))
{
while (redr.Read() == true)
{
Namespaces obj = new Namespaces()
{
Namespaces_id = redr[NAMESPACES.NAMESPACES_ID].ToString(),
Namespaces_name = redr[NAMESPACES.NAMESPACES_NAME].ToString(),
Notes = redr[NAMESPACES.NOTES].ToString(),
Active_id = redr[NAMESPACES.ACTIVE_ID].ToString()
};
list.Add(obj);
}
redr.Close();
}
return(list);
}
