public static DataTable GetMemberCardCodes(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT MEMBER_CARD_CODE, MEMBER_CODE FROM M_MEMBER_CARD"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetMembers(string paramFilterValues) { DataAccess da = new DataAccess(); // string sql = @"SELECT M_MEMBER.MEMBER_CODE, // M_MEMBER.TYPE_CODE, // M_MEMBER.FNAME || ' ' || M_MEMBER.MNAME || ' ' || M_MEMBER.LNAME as NAME, // M_MEMBER.CITY_CODE, // M_MEMBER.REGISTERED_BY, // M_MEMBER.REGISTERED_DATE, // M_MEMBER.ACTIVE_FLAG, // M_MEMBER.REASON_FOR_INACTIVE, // M_MEMBER.INACTIVE_DATE, // M_MEMBER.INACTIVATED_BY // FROM M_MEMBER // where FNAME like '%" + paramFilterValues + "%' OR MNAME like '%" + paramFilterValues + "%' OR LNAME like '%" + paramFilterValues + "%'"; string sql = @"SELECT MEMBER_CODE, M_MEMBER.TYPE_CODE, M_MEMBER.FNAME || ' ' || M_MEMBER.MNAME || ' ' || M_MEMBER.LNAME as NAME, CITY_CODE, REGISTERED_BY, REGISTERED_DATE, M_MEMBER.ACTIVE_FLAG, M_MEMBER.REASON_FOR_INACTIVE, INACTIVE_DATE, INACTIVATED_BY, M_LIBRARY_MEMBER_TYPE.TYPE_DESC FROM M_MEMBER inner join M_LIBRARY_MEMBER_TYPE on M_MEMBER.TYPE_CODE =M_LIBRARY_MEMBER_TYPE.TYPE_CODE where FNAME like '%" + paramFilterValues + "%' OR MNAME like '%" + paramFilterValues + "%' OR LNAME like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetBookSN(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT BOOK_CODE, BOOK_SN FROM M_BOOK_INVENTORY"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetEditions(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_EDITION.EDITION_CODE, M_EDITION.EDITION_DESC, M_EDITION.REMARKS FROM M_EDITION where EDITION_DESC like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetCardTypes(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_MEMBER_CARD_TYPES.CARD_TYPE, M_MEMBER_CARD_TYPES.TYPE_DESC, M_MEMBER_CARD_TYPES.NO_OF_BOOKS_ALLOWED FROM M_MEMBER_CARD_TYPES where TYPE_DESC like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetSources(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_BOOK_SOURCE.SOURCE_TYPE_CODE, M_BOOK_SOURCE.SOURCE_DESC, M_BOOK_SOURCE.REMARKS FROM M_BOOK_SOURCE where SOURCE_DESC like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetCategories(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_BOOK_CATEGORY.CATEGORY_CODE, M_BOOK_CATEGORY.CATEGORY_DESC, M_BOOK_CATEGORY.REMARKS FROM M_BOOK_CATEGORY where category_desc like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetMemberTypes(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_LIBRARY_MEMBER_TYPE.TYPE_CODE, M_LIBRARY_MEMBER_TYPE.TYPE_DESC, M_LIBRARY_MEMBER_TYPE.ACTIVE_FLAG, M_LIBRARY_MEMBER_TYPE.REASON_FOR_INACTIVE FROM M_LIBRARY_MEMBER_TYPE where TYPE_DESC like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetAuthors(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_AUTHOR.AUTHOR_CODE, M_AUTHOR.FNAME || ' ' || M_AUTHOR.MNANE || ' ' || M_AUTHOR.LNAME as NAME, M_AUTHOR.COUNTRY_CODE FROM M_AUTHOR where FNAME like '%" + paramFilterValues + "%' OR MNANE like '%" + paramFilterValues + "%' OR LNAME like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetBookInventories(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_BOOK_INVENTORY.BOOK_SN, M_BOOK_INVENTORY.BOOK_LOT_NO, M_BOOK_INVENTORY.BOOK_CODE, M_BOOK_INVENTORY.ENTRY_DATE, M_BOOK_INVENTORY.ENTERED_BY FROM M_BOOK_INVENTORY"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetFinePolicies(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_LIB_FINE_POLICY.FINE_CODE, M_LIB_FINE_POLICY.FINE_DESC, M_LIB_FINE_POLICY.FROM_DAYS, M_LIB_FINE_POLICY.TO_DAYS, M_LIB_FINE_POLICY.FINE_PER_DAY, M_LIB_FINE_POLICY.ACTIVE_FLAG, M_LIB_FINE_POLICY.REASON_FOR_INACTIVE FROM M_LIB_FINE_POLICY where FINE_DESC like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetBookAuthors(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_BOOK_AUTHORS.AUTHOR_CODE, M_BOOK_AUTHORS.FNAME, M_BOOK_AUTHORS.MNAME, M_BOOK_AUTHORS.LNAME, M_BOOK_AUTHORS.COUNTRY_CODEE FROM M_BOOK_AUTHORS where FNAME like '%" + paramFilterValues + "%' OR MNAME like '%" + paramFilterValues + "%' OR LNAME like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetDDLBooks(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_BOOK.BOOK_CODE, M_BOOK.BOOK_DESC, M_BOOK.PUBLICATION_CODE, M_BOOK.CATEGORY_CODE, M_BOOK.ACTIVE_FLAG, M_BOOK.REASON_FOR_INACTIVE FROM M_BOOK where BOOK_DESC like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static bool VerifyUser(BLibraryPro.User oparamObjBUser) { DataAccess da = new DataAccess(); //da.AddParameter("idec",OracleType.Int32, 1); //da.AddParameter("p_UserName", OracleType.NVarChar, oparamObjBUser.Username); //da.AddParameter("p_Password", OracleType.NVarChar, oparamObjBUser.Password); //da.AddParameter("p_DATA", OracleType.Cursor, ParameterDirection.Output); string sql = @" select UserName from M_LOGIN where USERNAME ='******' and pass_word ='" + oparamObjBUser.Password + @"' and isactive=1"; DataTable dt = new DataTable(); dt = da.ExecuteDataTable(sql, CommandType.Text); if (dt.Rows.Count > 0) { return true; } else return false; }
public static DataTable GetBookLots(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_BOOK_LOT.BOOK_LOT_NO, M_BOOK_LOT.BOOK_CODE, M_BOOK_LOT.EDITION_CODE, M_BOOK_LOT.YEAR_OF_PUBLICATION, M_BOOK_LOT.ISBN, M_BOOK_LOT.PRICE, M_BOOK_LOT.NO_OF_PAGES, M_BOOK_LOT.SOURCE_TYPE_CODE, M_BOOK_LOT.RECEIVED_ON, M_BOOK_LOT.NO_OF_BOOKS, M_BOOK.BOOK_DESC, M_EDITION.EDITION_DESC, M_BOOK_SOURCE.SOURCE_DESC FROM M_BOOK_LOT inner join M_BOOK on M_BOOK.BOOK_CODE=M_BOOK_LOT.BOOK_CODE inner join M_EDITION on M_EDITION.EDITION_CODE=M_BOOK_LOT.EDITION_CODE inner join M_BOOK_SOURCE on M_BOOK_SOURCE.SOURCE_TYPE_CODE=M_BOOK_LOT.SOURCE_TYPE_CODE"; return da.ExecuteDataTable(sql, CommandType.Text); }
public static DataTable GetBooks(string paramFilterValues) { DataAccess da = new DataAccess(); string sql = @"SELECT M_BOOK.BOOK_CODE, M_BOOK.BOOK_DESC, M_BOOK.PUBLICATION_CODE, M_BOOK.CATEGORY_CODE, M_BOOK.ACTIVE_FLAG, M_BOOK.REASON_FOR_INACTIVE, M_PUBLICATION.PUBLICATION_DESC, M_BOOK_CATEGORY.CATEGORY_DESC, M_AUTHOR.FNAME || ' ' || M_AUTHOR.MNANE || ' ' || M_AUTHOR.LNAME as AUTHORNAME, M_AUTHOR.AUTHOR_CODE, M_BOOK_LOT.BOOK_LOT_NO, M_BOOK_SOURCE.SOURCE_DESC FROM M_BOOK inner join M_PUBLICATION on M_BOOK.PUBLICATION_CODE = M_PUBLICATION.PUBLICATION_CODE inner join M_BOOK_CATEGORY on M_BOOK.CATEGORY_CODE=M_BOOK_CATEGORY.CATEGORY_CODE inner join M_BOOK_AUTHORS on M_BOOK_AUTHORS.BOOK_CODE=M_BOOK.BOOK_CODE inner join M_AUTHOR on M_BOOK_AUTHORS.AUTHOR_CODE=M_AUTHOR.AUTHOR_CODE inner join M_BOOK_LOT on M_BOOK_LOT.BOOK_CODE=M_BOOK.BOOK_CODE inner join M_BOOK_SOURCE on M_BOOK_SOURCE.SOURCE_TYPE_CODE=M_BOOK_LOT.SOURCE_TYPE_CODE where BOOK_DESC like '%" + paramFilterValues + "%'"; return da.ExecuteDataTable(sql, CommandType.Text); }