public static DataSet GetSearch(TMSLibrarianAttendanceDetails searchObject)
{
return(GetSearch(searchObject.LADAttendancedId, searchObject.LADLibraryManagerId, searchObject.LADLibrarianId, searchObject.LADMonth, searchObject.LADYear, searchObject.LADOneDate, searchObject.LADTwoDate, searchObject.LADThreeDate, searchObject.LADFourDate, searchObject.LADFiveDate, searchObject.LADSixDate, searchObject.LADSevenDate, searchObject.LADEightDate, searchObject.LADNineDate, searchObject.LADTenDate, searchObject.LADElevenDate, searchObject.LADTewelDate, searchObject.LADThirteenDate, searchObject.LADFourteenDate, searchObject.LADFifteenDate, searchObject.LADSixteenDate, searchObject.LADSeventeenDate, searchObject.LADEighteenDate, searchObject.LADNineteenDate, searchObject.LADTwentyDate, searchObject.LADTwentyOneDate, searchObject.LADTwentyTwoDate, searchObject.LADTwentyThreeDate, searchObject.LADTwentyFourDate, searchObject.LADTwentyFiveDate, searchObject.LADTwentySixDate, searchObject.LADTwentySevenDate, searchObject.LADTwentyEightDate, searchObject.LADTwentyNineDate, searchObject.LADThirtyDate, searchObject.LADThirtyOneDate, searchObject.LADAttendanceRemark, searchObject.LADAttendanceBy, searchObject.LADDate, searchObject.LADStatus));
}
public static void Update(TMSLibrarianAttendanceDetails tMSLibrarianAttendanceDetails, DbTransaction transaction)
{
tMSLibrarianAttendanceDetails.Update(transaction);
}
public static void Update(TMSLibrarianAttendanceDetails tMSLibrarianAttendanceDetails)
{
tMSLibrarianAttendanceDetails.Update();
}
public static TMSLibrarianAttendanceDetails[] Search(TMSLibrarianAttendanceDetails searchObject)
{
return Search ( searchObject.LADAttendancedId, searchObject.LADLibraryManagerId, searchObject.LADLibrarianId, searchObject.LADMonth, searchObject.LADYear, searchObject.LADOneDate, searchObject.LADTwoDate, searchObject.LADThreeDate, searchObject.LADFourDate, searchObject.LADFiveDate, searchObject.LADSixDate, searchObject.LADSevenDate, searchObject.LADEightDate, searchObject.LADNineDate, searchObject.LADTenDate, searchObject.LADElevenDate, searchObject.LADTewelDate, searchObject.LADThirteenDate, searchObject.LADFourteenDate, searchObject.LADFifteenDate, searchObject.LADSixteenDate, searchObject.LADSeventeenDate, searchObject.LADEighteenDate, searchObject.LADNineteenDate, searchObject.LADTwentyDate, searchObject.LADTwentyOneDate, searchObject.LADTwentyTwoDate, searchObject.LADTwentyThreeDate, searchObject.LADTwentyFourDate, searchObject.LADTwentyFiveDate, searchObject.LADTwentySixDate, searchObject.LADTwentySevenDate, searchObject.LADTwentyEightDate, searchObject.LADTwentyNineDate, searchObject.LADThirtyDate, searchObject.LADThirtyOneDate, searchObject.LADAttendanceRemark, searchObject.LADAttendanceBy, searchObject.LADDate, searchObject.LADStatus);
}
public static TMSLibrarianAttendanceDetails[] MapFrom(DataSet ds)
{
List<TMSLibrarianAttendanceDetails> objects;
// Initialise Collection.
objects = new List<TMSLibrarianAttendanceDetails>();
// 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_LibrarianAttendanceDetails] in DataSet.");
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
throw new ApplicationException("Table [dbo].[TMS_LibrarianAttendanceDetails] is empty.");
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSLibrarianAttendanceDetails instance = new TMSLibrarianAttendanceDetails();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return objects.ToArray();
}
public static TMSLibrarianAttendanceDetails Get(System.Int64 ladAttendancedId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSLibrarianAttendanceDetails instance;
instance = new TMSLibrarianAttendanceDetails();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSLibrarianAttendanceDetails_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, ladAttendancedId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSLibrarianAttendanceDetails ID:" + ladAttendancedId.ToString()+ " from Database.");
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom( ds.Tables[0].Rows[0] );
return instance;
}