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; }