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