public static void Populate(BLibraryPro.Member Member, string new_code)
{
DataAccess da = new DataAccess();
string sql = @"SELECT M_MEMBER.MEMBER_CODE,
M_MEMBER.TYPE_CODE,
M_MEMBER.FNAME,
M_MEMBER.MNAME,
M_MEMBER.LNAME,
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 MEMBER_CODE = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
Member.MemberCode = new_code;
Member.TypeCode = odr["TYPE_CODE"].ToString();
Member.FirstName = odr["FNAME"].ToString();
Member.MiddleName = odr["MNAME"].ToString();
Member.LastName = odr["LNAME"].ToString();
Member.CityCode = odr["CITY_CODE"].ToString();
Member.RegisteredBy = odr["REGISTERED_BY"].ToString();
Member.RegisteredDate = Convert.ToDateTime(odr["REGISTERED_DATE"].ToString());
Member.ActiveFlag = odr["ACTIVE_FLAG"].ToString();
Member.InactiveReason = odr["REASON_FOR_INACTIVE"].ToString();
Member.InactivedDate = Convert.ToDateTime(odr["INACTIVE_DATE"].ToString());
Member.InactivatedBy = odr["INACTIVATED_BY"].ToString();
}
}
public static void Populate(BLibraryPro.BookLot BookLot, string new_code)
{
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
FROM M_BOOK_LOT
where BOOK_LOT_NO = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
BookLot.BookLotNo = Convert.ToInt32(new_code);
BookLot.BookCode = Convert.ToInt32(odr["BOOK_CODE"].ToString());
BookLot.EditionCode = odr["EDITION_CODE"].ToString();
BookLot.YearOfPublication = Convert.ToInt32(odr["YEAR_OF_PUBLICATION"].ToString());
BookLot.ISBN = odr["ISBN"].ToString();
BookLot.Price = float.Parse(odr["PRICE"].ToString());
BookLot.NoOfPage = Convert.ToInt32(odr["NO_OF_PAGES"].ToString());
BookLot.SourceTypeCode = odr["SOURCE_TYPE_CODE"].ToString();
BookLot.ReceivedOn = Convert.ToDateTime(odr["RECEIVED_ON"].ToString());
BookLot.NoOfBooks = Convert.ToInt32(odr["NO_OF_BOOKS"].ToString());
}
}
public static string GetNewID(string ruleName)
{
//
DataAccess da = new DataAccess();
OracleDataReader odr;
decimal org_new_id= 0;
string new_val = "";
odr = da.ExecuteReader("select * from auto_num where rule_name = '"+ruleName+"'", CommandType.Text);
if (odr.Read())
{
string prefix = odr["PRE_FIX"].ToString();
string old_val = odr["CUR_VALUE"].ToString();
string pad_char = odr["PAD_CHAR"].ToString();
int len = Convert.ToInt32(odr["LENGTH"]);
string pad_val="";
for (int i = 0; i < len - prefix.Length-old_val.Length; i++)
{
pad_val += pad_char;
}
org_new_id = Convert.ToDecimal(odr["CUR_VALUE"]);
new_val = prefix + pad_val + org_new_id.ToString();
//update to new
odr.Close();
da.ExecuteNonQuery("update auto_num set cur_value = cur_value+1 where rule_name = '" + ruleName + "' ", CommandType.Text);
}
return new_val;
}
public static void Populate(BLibraryPro.Edition edition, string new_code)
{
DataAccess da = new DataAccess();
string sql = @"SELECT M_EDITION.EDITION_CODE,
M_EDITION.EDITION_DESC,
M_EDITION.REMARKS
FROM M_EDITION
where EDITION_CODE = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
edition.EditionCode = new_code;
edition.EditionDesc = odr["EDITION_DESC"].ToString();
edition.Remarks = odr["REMARKS"].ToString();
}
}
public static void Populate(BLibraryPro.CardType cardType, string new_code)
{
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 CARD_TYPE = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
cardType.CardTypeCode = new_code;
cardType.TypeDesc = odr["TYPE_DESC"].ToString();
cardType.BooksAllowed = Convert.ToInt32(odr["NO_OF_BOOKS_ALLOWED"]);
}
}
public static void Populate(BLibraryPro.BookSource source, string new_code)
{
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_TYPE_CODE = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
source.SourceTypeCode = new_code;
source.SourceDesc = odr["SOURCE_DESC"].ToString();
source.remarks = odr["REMARKS"].ToString();
}
}
public static void Populate(BLibraryPro.Category category, string new_code)
{
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_code = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
category.CategoryCode = new_code;
category.CategoryDesc = odr["CATEGORY_DESC"].ToString();
category.remarks = odr["REMARKS"].ToString();
}
}
public static void Populate(BLibraryPro.Publication publication, string new_code)
{
DataAccess da = new DataAccess();
string sql = @"SELECT M_PUBLICATION.PUBLICATION_CODE,
M_PUBLICATION.PUBLICATION_DESC,
M_PUBLICATION.COUNTRY_CODE,
M_PUBLICATION.ESTABLISHED_DATE
FROM M_PUBLICATION
where publication_code = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
//publication.PublicationCode = new_code;
publication.PublicationDesc = odr["PUBLICATION_DESC"].ToString();
publication.CountryCode = odr["COUNTRY_CODE"].ToString();
publication.EstDate = Convert.ToDateTime(odr["ESTABLISHED_DATE"].ToString());
}
}
public static void Populate(BLibraryPro.MemberType MemberType, string new_code)
{
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_CODE = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
MemberType.MemberTypeCode = new_code;
MemberType.TypeDesc = odr["TYPE_DESC"].ToString();
MemberType.ActiveFlag = odr["ACTIVE_FLAG"].ToString();
MemberType.Reason = odr["REASON_FOR_INACTIVE"].ToString();
}
}
public static void Populate(BLibraryPro.BookInventory BookInventory, string new_code)
{
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
where BOOK_SN = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
BookInventory.BookSn = new_code;
BookInventory.BookLotNo = Convert.ToInt32(odr["BOOK_LOT_NO"].ToString());
BookInventory.BookCode = Convert.ToInt32(odr["BOOK_CODE"].ToString());
BookInventory.EntryDate = Convert.ToDateTime(odr["ENTRY_DATE"].ToString());
BookInventory.EntryBy = odr["ENTERED_BY"].ToString();
}
}
public static void Populate(BLibraryPro.Author Author, string new_code)
{
DataAccess da = new DataAccess();
string sql = @"SELECT M_AUTHOR.AUTHOR_CODE,
M_AUTHOR.FNAME,
M_AUTHOR.MNANE,
M_AUTHOR.LNAME,
M_AUTHOR.COUNTRY_CODE
FROM M_AUTHOR
where AUTHOR_CODE = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
Author.AuthorCode = new_code;
Author.FirstName = odr["FNAME"].ToString();
Author.MiddleName = odr["MNANE"].ToString();
Author.LastName = odr["LNAME"].ToString();
Author.CountryCode = odr["COUNTRY_CODE"].ToString();
}
}
public static void Populate(BLibraryPro.FinePolicy FinePolicy, string new_code)
{
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_CODE = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
FinePolicy.FinePolicyCode = Convert.ToInt32(new_code);
FinePolicy.FinePolicyDesc = odr["FINE_DESC"].ToString();
FinePolicy.FromDays = Convert.ToInt32(odr["FROM_DAYS"]);
FinePolicy.ToDays = Convert.ToInt32(odr["TO_DAYS"]);
FinePolicy.FinePerDay = float.Parse(odr["FINE_PER_DAY"].ToString());
FinePolicy.ActiveFlag = odr["ACTIVE_FLAG"].ToString();
FinePolicy.Reason = odr["REASON_FOR_INACTIVE"].ToString();
}
}
public static void Populate(BLibraryPro.Book Book, string new_code)
{
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_CODE = '" + new_code + "'";
OracleDataReader odr = da.ExecuteReader(sql, CommandType.Text);
if (odr.Read())
{
Book.BookCode = Convert.ToInt32(new_code);
Book.BookDesc = odr["BOOK_DESC"].ToString();
Book.PublicationCode = odr["PUBLICATION_CODE"].ToString();
Book.CategoryCode = odr["CATEGORY_CODE"].ToString();
Book.ActiveFlag = odr["ACTIVE_FLAG"].ToString();
Book.ReasonForInactive = odr["REASON_FOR_INACTIVE"].ToString();
}
}