public static string DeleteBook(BLibraryPro.Book Book) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_BOOK WHERE BOOK_CODE = '" + Book.BookCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Deleted Successfully"; }
public static string DeleteMembers(BLibraryPro.Member Member) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_MEMBER WHERE MEMBER_CODE = '" + Member.MemberCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Deleted Successfully"; }
public static string DeleteFinePolicy(BLibraryPro.FinePolicy FinePolicy) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_LIB_FINE_POLICY WHERE FINE_CODE = '" + FinePolicy.FinePolicyCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Deleted Successfully"; }
public static string DeleteSource(BLibraryPro.BookSource source) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_BOOK_SOURCE WHERE SOURCE_TYPE_CODE = '" + source.SourceTypeCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Deleted Successfully"; }
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 string DeleteMemberType(BLibraryPro.MemberType memberType) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_LIBRARY_MEMBER_TYPE WHERE TYPE_CODE = '" + memberType.MemberTypeCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Deleted Successfully"; }
public static string DeleteCardType(BLibraryPro.CardType cardType) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_MEMBER_CARD_TYPES WHERE CARD_TYPE = '" + cardType.CardTypeCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Deleted Successfully"; }
public static string DeleteBookInventory(BLibraryPro.BookInventory BookInventory) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_BOOK_INVENTORY WHERE BOOK_SN = '" + BookInventory.BookSn + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Deleted Successfully"; }
public static string DeleteAuthor(BLibraryPro.Author Author) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_AUTHOR WHERE AUTHOR_CODE = '" + Author.AuthorCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Deleted Successfully"; }
public static string DeleteEdition(BLibraryPro.Edition ObjEdition) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_EDITION WHERE EDITION_CODE = '" + ObjEdition.EditionCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Deleted Successfully"; }
public static string DeletePublication(BLibraryPro.Publication Publication) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_PUBLICATION WHERE PUBLICATION_CODE ='" + Publication.PublicationCode +@"'"); da.ExecuteNonQuery(sql,CommandType.Text); return "Data Deleted Successfully"; }
public static string DeleteCategory(BLibraryPro.Category category) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_BOOK_CATEGORY WHERE CATEGORY_CODE = '" + category.CategoryCode + "'"); da.ExecuteNonQuery(sql,CommandType.Text); return "Data Deleted Successfully"; }
public static string DeleteBookLot(BLibraryPro.BookLot BookLot) { DataAccess da = new DataAccess(); string sql = string.Format(@"DELETE FROM M_BOOK_LOT WHERE BOOK_LOT_NO = '" + BookLot.BookLotNo + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Deleted Successfully"; }
public static string UpdateCategory(BLibraryPro.Category category) { DataAccess da = new DataAccess(); string sql = string.Format(@"UPDATE M_BOOK_CATEGORY SET CATEGORY_DESC = '" + category.CategoryDesc + @"', REMARKS= '" + category.remarks + @"' WHERE CATEGORY_CODE = '" + category.CategoryCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Updated Successfully"; }
public static string UpdateEditon(BLibraryPro.Edition ObjEdition) { DataAccess da = new DataAccess(); string sql = string.Format(@"UPDATE M_EDITION SET EDITION_DESC = '" + ObjEdition.EditionDesc + @"', REMARKS= '" + ObjEdition.Remarks + @"' WHERE EDITION_CODE = '" + ObjEdition.EditionCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Updated Successfully"; }
public static string UpdateCardType(BLibraryPro.CardType cardType) { DataAccess da = new DataAccess(); string sql = string.Format(@"UPDATE M_MEMBER_CARD_TYPES SET TYPE_DESC = '" + cardType.TypeDesc + @"', NO_OF_BOOKS_ALLOWED= '" + cardType.BooksAllowed + @"' WHERE CARD_TYPE = '" + cardType.CardTypeCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Updated Successfully"; }
public static string UpdatePublication(BLibraryPro.Publication publication) { DataAccess da = new DataAccess(); string sql = string.Format(@"UPDATE M_PUBLICATION SET PUBLICATION_DESC = '" +publication.PublicationDesc+ @"', COUNTRY_CODE = '" + publication.CountryCode + @"',ESTABLISHED_DATE = to_date('" + Convert.ToDateTime(publication.EstDate).ToShortDateString() + "','MM/dd/yyyy')" + @" WHERE PUBLICATION_CODE = '" + publication.PublicationCode + @"'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Updated Successfully"; }
public static string UpdateSource(BLibraryPro.BookSource source) { DataAccess da = new DataAccess(); string sql = string.Format(@"UPDATE M_BOOK_SOURCE SET SOURCE_DESC = '" + source.SourceDesc + @"', REMARKS= '" + source.remarks + @"' WHERE SOURCE_TYPE_CODE = '" + source.SourceTypeCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Updated Successfully"; }
public static string UpdateMemberType(BLibraryPro.MemberType memberType) { DataAccess da = new DataAccess(); string sql = string.Format(@"UPDATE M_LIBRARY_MEMBER_TYPE SET TYPE_DESC = '" + memberType.TypeDesc + @"', ACTIVE_FLAG= '" + memberType.ActiveFlag + @"', REASON_FOR_INACTIVE= '" + memberType.Reason + @"' WHERE TYPE_CODE = '" + memberType.MemberTypeCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Updated Successfully"; }
public static string UpdateBookAuthor(BLibraryPro.BookAuthors BookAuthors) { DataAccess da = new DataAccess(); string sql = string.Format(@"UPDATE M_BOOK_AUTHORS SET BOOK_LOT_NO = '" + BookAuthors.BookLotNo + @"', BOOK_CODE = '" + BookAuthors.BookCode + @"', AUTHOR_CODE = '" + BookAuthors.AuthorCode + @"' WHERE AUTHOR_CODE = '" + BookAuthors.AuthorCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Updated Successfully"; }
public static string SaveEdition(BLibraryPro.Edition ObjEdition) { DataAccess da = new DataAccess(); string new_id = BLibraryPro.MISC.GetNewID("EDITION"); string sql = string.Format(@"INSERT INTO M_EDITION (EDITION_CODE ,EDITION_DESC,REMARKS) VALUES('" + new_id + @"',' " + ObjEdition.EditionDesc + @"','" + ObjEdition.Remarks + @"' ) " ); da.ExecuteNonQuery(sql, CommandType.Text); return "Data added Successfully"; }
public static string UpdateBookInventory(BLibraryPro.BookInventory BookInventory) { DataAccess da = new DataAccess(); string sql = string.Format(@"UPDATE M_BOOK_INVENTORY SET BOOK_LOT_NO = '" + BookInventory.BookLotNo + @"', BOOK_CODE = '" + BookInventory.BookCode + @"', ENTRY_DATE = '" + BookInventory.EntryDate + @"', ENTERED_BY = '" + BookInventory.EntryBy + @"' WHERE BOOK_SN = '" + BookInventory.BookSn + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Updated Successfully"; }
public static string UpdateAuthor(BLibraryPro.Author Author) { DataAccess da = new DataAccess(); string sql = string.Format(@"UPDATE M_AUTHOR SET FNAME = '" + Author.FirstName + @"', MNANE = '" + Author.MiddleName + @"', LNAME = '" + Author.LastName + @"', COUNTRY_CODE = '" + Author.CountryCode + @"' WHERE AUTHOR_CODE = '" + Author.AuthorCode + "'"); da.ExecuteNonQuery(sql, CommandType.Text); return "Data Updated Successfully"; }
public static string SaveCategory(BLibraryPro.Category ObjCategory) { DataAccess da = new DataAccess(); string new_id = BLibraryPro.MISC.GetNewID("CATEGORY"); string sql = string.Format(@"INSERT INTO M_BOOK_CATEGORY (CATEGORY_CODE ,CATEGORY_DESC,REMARKS) VALUES('" + new_id + @"',' " + ObjCategory.CategoryDesc + @"','" + ObjCategory.remarks + @"' ) " ); da.ExecuteNonQuery(sql, CommandType.Text); return "Data added Successfully"; }
public static string SaveCardType(BLibraryPro.CardType ObjCardType) { DataAccess da = new DataAccess(); string new_id = BLibraryPro.MISC.GetNewID("CARDTYPE"); string sql = string.Format(@"INSERT INTO M_MEMBER_CARD_TYPES (CARD_TYPE ,TYPE_DESC,NO_OF_BOOKS_ALLOWED) VALUES('" + new_id + @"',' " + ObjCardType.TypeDesc + @"','" + ObjCardType.BooksAllowed + @"' ) " ); da.ExecuteNonQuery(sql, CommandType.Text); return "Data added Successfully"; }
public static string SaveAuthor(BLibraryPro.Author ObjAuthor) { DataAccess da = new DataAccess(); string new_id = BLibraryPro.MISC.GetNewID("AUTHOR"); string sql = string.Format(@"INSERT INTO M_AUTHOR (AUTHOR_CODE,FNAME,MNANE,LNAME,COUNTRY_CODE) VALUES('" + new_id + @"','" + ObjAuthor.FirstName + @"','" + ObjAuthor.MiddleName + @"','" + ObjAuthor.LastName + @"','" + ObjAuthor.CountryCode + @"') " ); da.ExecuteNonQuery(sql, CommandType.Text); return new_id; }
public static string SaveBookInventory(BLibraryPro.BookInventory ObjBookInventory) { DataAccess da = new DataAccess(); string new_id = BLibraryPro.MISC.GetNewID("BOOKINVENTORY"); string sql = string.Format(@"INSERT INTO M_BOOK_INVENTORY (BOOK_SN,BOOK_LOT_NO,BOOK_CODE,ENTRY_DATE,ENTERED_BY) VALUES('" + new_id + @"','" + ObjBookInventory.BookLotNo + @"','" + ObjBookInventory.BookCode + @"','" + ObjBookInventory.EntryDate + @"','" + ObjBookInventory.EntryBy + @"') " ); da.ExecuteNonQuery(sql, CommandType.Text); return "Data added Successfully"; }
public static string SaveFinePolicy(BLibraryPro.FinePolicy ObjFinePolicy) { DataAccess da = new DataAccess(); int new_id = Convert.ToInt32(BLibraryPro.MISC.GetNewID("FINEPOLICY")); string sql = string.Format(@"INSERT INTO M_LIB_FINE_POLICY (FINE_CODE ,FINE_DESC,FROM_DAYS,TO_DAYS,FINE_PER_DAY,ACTIVE_FLAG,REASON_FOR_INACTIVE) VALUES('" + new_id + @"',' " + ObjFinePolicy.FinePolicyDesc + @"','" + ObjFinePolicy.FromDays + @"','" + ObjFinePolicy.ToDays + @"','" + ObjFinePolicy.FinePerDay + @"','" + ObjFinePolicy.ActiveFlag + @"','" + ObjFinePolicy.Reason + @"' ) " ); da.ExecuteNonQuery(sql, CommandType.Text); return "Data added Successfully"; }
public static string SaveMemberType(BLibraryPro.MemberType ObjMemberType) { DataAccess da = new DataAccess(); string new_id = BLibraryPro.MISC.GetNewID("MEMBERTYPE"); string sql = string.Format(@"INSERT INTO M_LIBRARY_MEMBER_TYPE (TYPE_CODE ,TYPE_DESC,ACTIVE_FLAG,REASON_FOR_INACTIVE) VALUES('" + new_id + @"',' " + ObjMemberType.TypeDesc + @"','" + ObjMemberType.ActiveFlag + @"','" + ObjMemberType.Reason + @"' ) " ); da.ExecuteNonQuery(sql, CommandType.Text); return "Data added Successfully"; }
public static string SaveSource(BLibraryPro.BookSource ObjSource) { DataAccess da = new DataAccess(); string new_id = BLibraryPro.MISC.GetNewID("SOURCE"); string sql = string.Format(@"INSERT INTO M_BOOK_SOURCE (SOURCE_TYPE_CODE ,SOURCE_DESC,REMARKS) VALUES('" + new_id + @"',' " + ObjSource.SourceDesc + @"','" + ObjSource.remarks + @"' ) " ); da.ExecuteNonQuery(sql, CommandType.Text); return "Data added Successfully"; }