public static DataSet GetSearch(TMSAttendanceDetails searchObject)
{
return GetSearch(searchObject.SADAttendancedId, searchObject.SADFacultyId, searchObject.SADStudentId, searchObject.SADSchoolId, searchObject.SADSchoolSubId, searchObject.SADSubjectId, searchObject.SADMonth, searchObject.SADYear, searchObject.SADOneDate, searchObject.SADTwoDate, searchObject.SADThreeDate, searchObject.SADFourDate, searchObject.SADFiveDate, searchObject.SADSixDate, searchObject.SADSevenDate, searchObject.SADEightDate, searchObject.SADNineDate, searchObject.SADTenDate, searchObject.SADElevenDate, searchObject.SADTewelDate, searchObject.SADThirteenDate, searchObject.SADFourteenDate, searchObject.SADFifteenDate, searchObject.SADSixteenDate, searchObject.SADSeventeenDate, searchObject.SADEighteenDate, searchObject.SADNineteenDate, searchObject.SADTwentyDate, searchObject.SADTwentyOneDate, searchObject.SADTwentyTwoDate, searchObject.SADTwentyThreeDate, searchObject.SADTwentyFourDate, searchObject.SADTwentyFiveDate, searchObject.SADTwentySixDate, searchObject.SADTwentySevenDate, searchObject.SADTwentyEightDate, searchObject.SADTwentyNineDate, searchObject.SADThirtyDate, searchObject.SADThirtyOneDate, searchObject.SADAttendanceRemark, searchObject.SADAttendanceBy, searchObject.SADDate, searchObject.SADStatus);
}
public static DataSet GetSearch(TMSAttendanceDetails searchObject)
{
return(GetSearch(searchObject.SADAttendancedId, searchObject.SADFacultyId, searchObject.SADStudentId, searchObject.SADSchoolId, searchObject.SADSchoolSubId, searchObject.SADSubjectId, searchObject.SADMonth, searchObject.SADYear, searchObject.SADOneDate, searchObject.SADTwoDate, searchObject.SADThreeDate, searchObject.SADFourDate, searchObject.SADFiveDate, searchObject.SADSixDate, searchObject.SADSevenDate, searchObject.SADEightDate, searchObject.SADNineDate, searchObject.SADTenDate, searchObject.SADElevenDate, searchObject.SADTewelDate, searchObject.SADThirteenDate, searchObject.SADFourteenDate, searchObject.SADFifteenDate, searchObject.SADSixteenDate, searchObject.SADSeventeenDate, searchObject.SADEighteenDate, searchObject.SADNineteenDate, searchObject.SADTwentyDate, searchObject.SADTwentyOneDate, searchObject.SADTwentyTwoDate, searchObject.SADTwentyThreeDate, searchObject.SADTwentyFourDate, searchObject.SADTwentyFiveDate, searchObject.SADTwentySixDate, searchObject.SADTwentySevenDate, searchObject.SADTwentyEightDate, searchObject.SADTwentyNineDate, searchObject.SADThirtyDate, searchObject.SADThirtyOneDate, searchObject.SADAttendanceRemark, searchObject.SADAttendanceBy, searchObject.SADDate, searchObject.SADStatus));
}
public static void Update(TMSAttendanceDetails tMSAttendanceDetails, DbTransaction transaction)
{
tMSAttendanceDetails.Update(transaction);
}
public static void Update(TMSAttendanceDetails tMSAttendanceDetails)
{
tMSAttendanceDetails.Update();
}
public static TMSAttendanceDetails[] MapFrom(DataSet ds)
{
List<TMSAttendanceDetails> objects;
// Initialise Collection.
objects = new List<TMSAttendanceDetails>();
// 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_AttendanceDetails] in DataSet.");
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
throw new ApplicationException("Table [dbo].[TMS_AttendanceDetails] is empty.");
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSAttendanceDetails instance = new TMSAttendanceDetails();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return objects.ToArray();
}
public static TMSAttendanceDetails Get(System.Int64 sadAttendancedId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSAttendanceDetails instance;
instance = new TMSAttendanceDetails();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSAttendanceDetails_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, sadAttendancedId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSAttendanceDetails ID:" + sadAttendancedId.ToString()+ " from Database.");
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom( ds.Tables[0].Rows[0] );
return instance;
}