public static TMSEvolutionOfLiteraryAbilities Get(System.Int64 elaAbilityId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSEvolutionOfLiteraryAbilities instance;
instance = new TMSEvolutionOfLiteraryAbilities();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSEvolutionOfLiteraryAbilities_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, elaAbilityId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
throw new ApplicationException("Could not get TMSEvolutionOfLiteraryAbilities ID:" + elaAbilityId.ToString() + " from Database.");
}
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom(ds.Tables[0].Rows[0]);
return(instance);
}
public static TMSEvolutionOfLiteraryAbilities[] Search(System.Int64?elaAbilityId, System.Int64?elaSchoolId, System.Int64?elaSchoolSubId, System.Int64?elaStudentLoginId, System.String elaAllLetters, System.String elaNumbers, System.String elaColours, System.String elaShape, System.String elaVegetableFruits, System.String elaAnimalBirds, System.String elaMeansOfTransport, System.String elaCoomonArticleSchoolHome, System.String elaMyNamePrint, System.String elaLikeComeToSchool, System.String elaArticulateWell, System.String elaRecite, System.String elaStoryTell, System.String elaExpressIdeas, System.String elaDevelopeNewWords, System.String elaConverseFairlyWell, System.String elaFormLetters, System.String elaMakeSimplePattern, System.String elaAddedByType, System.Int64?elaAddedByLoginId, System.DateTime?elaDate, System.Int32?elaStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSEvolutionOfLiteraryAbilities_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, elaAbilityId, elaSchoolId, elaSchoolSubId, elaStudentLoginId, elaAllLetters, elaNumbers, elaColours, elaShape, elaVegetableFruits, elaAnimalBirds, elaMeansOfTransport, elaCoomonArticleSchoolHome, elaMyNamePrint, elaLikeComeToSchool, elaArticulateWell, elaRecite, elaStoryTell, elaExpressIdeas, elaDevelopeNewWords, elaConverseFairlyWell, elaFormLetters, elaMakeSimplePattern, elaAddedByType, elaAddedByLoginId, elaDate, elaStatus);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSEvolutionOfLiteraryAbilities.MapFrom(ds));
}
public static TMSEvolutionOfLiteraryAbilities[] MapFrom(DataSet ds)
{
List <TMSEvolutionOfLiteraryAbilities> objects;
// Initialise Collection.
objects = new List <TMSEvolutionOfLiteraryAbilities>();
// Validation.
if (ds == null)
{
throw new ApplicationException("Cannot map to dataset null.");
}
else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
{
return(objects.ToArray());
}
if (ds.Tables[TABLE_NAME] == null)
{
throw new ApplicationException("Cannot find table [dbo].[TMS_EvolutionOfLiteraryAbilities] in DataSet.");
}
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
{
throw new ApplicationException("Table [dbo].[TMS_EvolutionOfLiteraryAbilities] is empty.");
}
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSEvolutionOfLiteraryAbilities instance = new TMSEvolutionOfLiteraryAbilities();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return(objects.ToArray());
}
public static void Update(TMSEvolutionOfLiteraryAbilities tMSEvolutionOfLiteraryAbilities, DbTransaction transaction)
{
tMSEvolutionOfLiteraryAbilities.Update(transaction);
}
public static void Update(TMSEvolutionOfLiteraryAbilities tMSEvolutionOfLiteraryAbilities)
{
tMSEvolutionOfLiteraryAbilities.Update();
}
public static TMSEvolutionOfLiteraryAbilities[] Search(TMSEvolutionOfLiteraryAbilities searchObject)
{
return Search ( searchObject.ELAAbilityId, searchObject.ELASchoolId, searchObject.ELASchoolSubId, searchObject.ELAStudentLoginId, searchObject.ELAAllLetters, searchObject.ELANumbers, searchObject.ELAColours, searchObject.ELAShape, searchObject.ELAVegetableFruits, searchObject.ELAAnimalBirds, searchObject.ELAMeansOfTransport, searchObject.ELACoomonArticleSchoolHome, searchObject.ELAMyNamePrint, searchObject.ELALikeComeToSchool, searchObject.ELAArticulateWell, searchObject.ELARecite, searchObject.ELAStoryTell, searchObject.ELAExpressIdeas, searchObject.ELADevelopeNewWords, searchObject.ELAConverseFairlyWell, searchObject.ELAFormLetters, searchObject.ELAMakeSimplePattern, searchObject.ELAAddedByType, searchObject.ELAAddedByLoginId, searchObject.ELADate, searchObject.ELAStatus);
}
public static TMSEvolutionOfLiteraryAbilities[] MapFrom(DataSet ds)
{
List<TMSEvolutionOfLiteraryAbilities> objects;
// Initialise Collection.
objects = new List<TMSEvolutionOfLiteraryAbilities>();
// Validation.
if (ds == null)
throw new ApplicationException("Cannot map to dataset null.");
else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
return objects.ToArray();
if (ds.Tables[TABLE_NAME] == null)
throw new ApplicationException("Cannot find table [dbo].[TMS_EvolutionOfLiteraryAbilities] in DataSet.");
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
throw new ApplicationException("Table [dbo].[TMS_EvolutionOfLiteraryAbilities] is empty.");
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSEvolutionOfLiteraryAbilities instance = new TMSEvolutionOfLiteraryAbilities();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return objects.ToArray();
}
public static TMSEvolutionOfLiteraryAbilities Get(System.Int64 elaAbilityId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSEvolutionOfLiteraryAbilities instance;
instance = new TMSEvolutionOfLiteraryAbilities();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSEvolutionOfLiteraryAbilities_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, elaAbilityId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSEvolutionOfLiteraryAbilities ID:" + elaAbilityId.ToString()+ " from Database.");
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom( ds.Tables[0].Rows[0] );
return instance;
}
public static DataSet GetSearch(TMSEvolutionOfLiteraryAbilities searchObject)
{
return(GetSearch(searchObject.ELAAbilityId, searchObject.ELASchoolId, searchObject.ELASchoolSubId, searchObject.ELAStudentLoginId, searchObject.ELAAllLetters, searchObject.ELANumbers, searchObject.ELAColours, searchObject.ELAShape, searchObject.ELAVegetableFruits, searchObject.ELAAnimalBirds, searchObject.ELAMeansOfTransport, searchObject.ELACoomonArticleSchoolHome, searchObject.ELAMyNamePrint, searchObject.ELALikeComeToSchool, searchObject.ELAArticulateWell, searchObject.ELARecite, searchObject.ELAStoryTell, searchObject.ELAExpressIdeas, searchObject.ELADevelopeNewWords, searchObject.ELAConverseFairlyWell, searchObject.ELAFormLetters, searchObject.ELAMakeSimplePattern, searchObject.ELAAddedByType, searchObject.ELAAddedByLoginId, searchObject.ELADate, searchObject.ELAStatus));
}
public static void Update(TMSEvolutionOfLiteraryAbilities tMSEvolutionOfLiteraryAbilities, DbTransaction transaction)
{
tMSEvolutionOfLiteraryAbilities.Update(transaction);
}
public static void Update(TMSEvolutionOfLiteraryAbilities tMSEvolutionOfLiteraryAbilities)
{
tMSEvolutionOfLiteraryAbilities.Update();
}
