コード例 #1
0
        public void ReturnBook(Model.Transaction oMTransaction)
        {
            try
            {
                osb.ConnectionString = sConnectionString;
                ddq = new DatabaseQuery.DBQuery();
                ddq.ConnectionString = osb.ConnectionString;

                ddq.CommandText = "SP_RETURN_BOOK";
                ddq.AddParamer("@BOOK_ID", SqlDbType.VarChar, oMTransaction.BOOK_ID);
                ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oMTransaction.PERSON_ID);
                ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO);
                ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oMTransaction.MODIFIED_DATE);
                ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oMTransaction.MODIFIED_BY);
                ddq.AddParamer("@TOTAL_AMOUNT", SqlDbType.Decimal, oMTransaction.TOTAL_AMOUNT);
                ddq.AddParamer("@REMARKS", SqlDbType.VarChar, oMTransaction.REMARKS);
                ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS);

                ddq.ExecuteNonQuery(CommandType.StoredProcedure);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
        public DataTable getResultWinner(DateTime dStart, DateTime dEnd, string sElectionCode)
        {
            try
            {
                osb.ConnectionString = sConnectionString;
                ddq = new DatabaseQuery.DBQuery();
                ddq.ConnectionString = osb.ConnectionString;

                ddq.AddParamer("@DATE_FROM", SqlDbType.NVarChar, dStart.ToString("yyyy-MM-dd"));
                ddq.AddParamer("@DATE_TO", SqlDbType.NVarChar, dEnd.ToString("yyyy-MM-dd"));
                ddq.AddParamer("@ELECTION_CODE", SqlDbType.NVarChar, sElectionCode);

                ddq.CommandText = "sp_getresult";

                ds = ddq.GetDataset(CommandType.StoredProcedure);

                return(ds.Tables.Count > 0 ? ds.Tables[0] : null);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #3
0
        public void UpdateBorrower(Model.Borrower oData)
        {
            try
            {
                osb.ConnectionString = sConnectionString;
                ddq = new DatabaseQuery.DBQuery();
                ddq.ConnectionString = osb.ConnectionString;

                ddq.CommandText = "SP_UPDATE_BORROWER";
                ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oData.PERSON_ID);
                ddq.AddParamer("@FIRST_NAME", SqlDbType.VarChar, oData.FIRST_NAME);
                ddq.AddParamer("@MIDDLE_NAME", SqlDbType.VarChar, oData.MIDDLE_NAME);
                ddq.AddParamer("@LAST_NAME", SqlDbType.VarChar, oData.LAST_NAME);
                ddq.AddParamer("@DOB", SqlDbType.VarChar, oData.DOB);
                ddq.AddParamer("@AGE", SqlDbType.VarChar, oData.AGE);
                ddq.AddParamer("@CONTACT_NO", SqlDbType.VarChar, oData.CONTACT_NO);
                ddq.AddParamer("@ADDRESS", SqlDbType.VarChar, oData.ADDRESS);
                ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oData.MODIFIED_DATE);
                ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oData.MODIFIED_BY);
                ddq.AddParamer("@STATUS", SqlDbType.VarChar, oData.STATUS);
                ddq.AddParamer("@PROFILE_PIC", SqlDbType.VarChar, oData.PROFILE_PIC);

                ddq.ExecuteNonQuery(CommandType.StoredProcedure);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #4
0
        public void UpdateBookDetails(Model.Transaction oMTransaction)
        {
            try
            {
                osb.ConnectionString = sConnectionString;
                ddq = new DatabaseQuery.DBQuery();
                ddq.ConnectionString = osb.ConnectionString;

                ddq.CommandText = "SP_UPDATE_BOOK_DETAILS";
                ddq.AddParamer("@ID", SqlDbType.VarChar, oMTransaction.BOOK_ID);
                ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO);
                ddq.AddParamer("@TITLE", SqlDbType.VarChar, oMTransaction.TITLE);
                ddq.AddParamer("@SUBJECT", SqlDbType.VarChar, oMTransaction.SUBJECT);
                ddq.AddParamer("@CATEGORY", SqlDbType.VarChar, oMTransaction.CATEGORY);
                ddq.AddParamer("@AUTHOR", SqlDbType.VarChar, oMTransaction.AUTHOR);
                ddq.AddParamer("@PUBLISH_DATE", SqlDbType.VarChar, oMTransaction.PUBLISH_DATE);
                ddq.AddParamer("@LOCATION", SqlDbType.VarChar, oMTransaction.LOCATION);
                ddq.AddParamer("@BOOK_PRICE", SqlDbType.VarChar, oMTransaction.BOOK_PRICE);
                ddq.AddParamer("@RENT_PRICE", SqlDbType.VarChar, oMTransaction.RENT_PRICE);
                ddq.AddParamer("@ISBN_NUMBER", SqlDbType.VarChar, oMTransaction.ISBN_NUMBER);
                ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oMTransaction.MODIFIED_DATE);
                ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oMTransaction.MODIFIED_BY);
                ddq.AddParamer("@REMARKS", SqlDbType.VarChar, oMTransaction.REMARKS);
                ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS);
                ddq.ExecuteNonQuery(CommandType.StoredProcedure);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #5
0
        public void RequestBook(Model.Transaction oMTransaction)
        {
            try
            {
                osb.ConnectionString = sConnectionString;
                ddq = new DatabaseQuery.DBQuery();
                ddq.ConnectionString = osb.ConnectionString;

                ddq.CommandText = "SP_REQUEST_BOOK";
                ddq.AddParamer("@ID", SqlDbType.VarChar, oMTransaction.BOOK_ID);
                ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oMTransaction.PERSON_ID);
                ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO);
                ddq.AddParamer("@TITLE", SqlDbType.VarChar, oMTransaction.TITLE);
                ddq.AddParamer("@SUBJECT", SqlDbType.VarChar, oMTransaction.SUBJECT);
                ddq.AddParamer("@CATEGORY", SqlDbType.VarChar, oMTransaction.CATEGORY);
                ddq.AddParamer("@AUTHOR", SqlDbType.VarChar, oMTransaction.AUTHOR);
                ddq.AddParamer("@PUBLISH_DATE", SqlDbType.VarChar, oMTransaction.PUBLISH_DATE);
                ddq.AddParamer("@ISBN_NUMBER", SqlDbType.VarChar, oMTransaction.ISBN_NUMBER);
                ddq.AddParamer("@LOCATION", SqlDbType.VarChar, oMTransaction.LOCATION);
                ddq.AddParamer("@BOOK_PRICE", SqlDbType.VarChar, oMTransaction.BOOK_PRICE);
                ddq.AddParamer("@RENT_PRICE", SqlDbType.VarChar, oMTransaction.RENT_PRICE);
                ddq.AddParamer("@DAYS_BORROWED", SqlDbType.VarChar, oMTransaction.TOTAL_DAYS);
                ddq.AddParamer("@ADDED_DATE", SqlDbType.VarChar, oMTransaction.ADDED_DATE);
                ddq.AddParamer("@ADDED_BY", SqlDbType.VarChar, oMTransaction.ADDED_BY);
                ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS);

                ddq.ExecuteNonQuery(CommandType.StoredProcedure);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }