Package com.masai.Dao

Class AdminDaoImpl

java.lang.Object

com.masai.Dao.AdminDaoImpl

All Implemented Interfaces:

AdminDao

public class AdminDaoImpl
extends Object
implements AdminDao

Constructor Summary

Constructors

Constructor	Description
AdminDaoImpl()

Method Summary

Modifier and Type	Method	Description
ResultSet	getAllBuyer()	Retrieve all active buyers.
ResultSet	getAllProducts()	Retrieve all products.
ResultSet	getAllProductsByCategory(String CatName)	Retrieve all products belonging to a specific category.
ResultSet	getAllProductsByInAccendingOrderByPrice()	Retrieve all products sorted in ascending order of price.
ResultSet	getAllProductsByQuantity(int from, int to)	Retrieve all products within a specified quantity range.
ResultSet	getAllProductsBySellerUsername(String username)	Retrieve all products belonging to a specific seller's username.
ResultSet	getAllSeller()	Retrieve all active sellers.
ResultSet	getAllSoldProducts()	Retrieve all sold products.
ResultSet	getAllTransaction()	Retrieve all transactions.
ResultSet	getAllTransactionbyDateRange(LocalDate startDate, LocalDate endDate)	Retrieve all transactions within a specific date range.
ResultSet	getAllTransactionByGSTPercentage()	Retrieve all transactions sorted by GST percentage.
ResultSet	getAllTransactionByPurchaseDate()	Retrieve all transactions sorted by purchase date.
ResultSet	getAllTransactionByQuantity()	Retrieve all transactions sorted by quantity.
ResultSet	getAllTransactionByTotalPrice()	Retrieve all transactions sorted by total price.
ResultSet	getTransactionById(int id)	Retrieve a transaction by its ID.
Boolean	loginAdmin(String adminId, String password)	Login as an admin.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

AdminDaoImpl

public AdminDaoImpl()

Method Details

loginAdmin

public Boolean loginAdmin(String adminId,
 String password)

Login as an admin.

Specified by:

loginAdmin in interface AdminDao

Parameters:

adminId - The admin ID.

password - The admin password.

Returns:

True if the login is successful, False otherwise.

Throws:

InvalidCredentialsException - If the admin ID or password is invalid.

getAllBuyer

public ResultSet getAllBuyer()
                      throws RecordNotFoundException

Retrieve all active buyers.

Specified by:

getAllBuyer in interface AdminDao

Returns:

A ResultSet containing information about all active buyers.

Throws:

RecordNotFoundException - If no active buyers are found.

getAllSeller

public ResultSet getAllSeller()

Retrieve all active sellers.

Specified by:

getAllSeller in interface AdminDao

Returns:

A ResultSet containing information about all active sellers.

Throws:

RecordNotFoundException - If no active sellers are found.

getAllProducts

public ResultSet getAllProducts()
                         throws RecordNotFoundException

Retrieve all products.

Specified by:

getAllProducts in interface AdminDao

Returns:

A ResultSet containing information about all products.

Throws:

RecordNotFoundException - If no products are found.

getAllSoldProducts

public ResultSet getAllSoldProducts()
                             throws RecordNotFoundException

Retrieve all sold products.

Specified by:

getAllSoldProducts in interface AdminDao

Returns:

A ResultSet containing information about all sold products.

Throws:

RecordNotFoundException - If no sold products are found.

getAllProductsByCategory

public ResultSet getAllProductsByCategory(String CatName)
                                   throws RecordNotFoundException

Retrieve all products belonging to a specific category.

Specified by:

getAllProductsByCategory in interface AdminDao

Parameters:

categoryName - The name of the category.

Returns:

A ResultSet containing information about all products in the specified category.

Throws:

RecordNotFoundException - If no products are found in the specified category.

getAllProductsBySellerUsername

public ResultSet getAllProductsBySellerUsername(String username)
                                         throws RecordNotFoundException

Retrieve all products belonging to a specific seller's username.

Specified by:

getAllProductsBySellerUsername in interface AdminDao

Parameters:

username - The username of the seller.

Returns:

A ResultSet containing information about all products belonging to the specified seller.

Throws:

RecordNotFoundException - If no products are found for the specified seller.

getAllProductsByInAccendingOrderByPrice

public ResultSet getAllProductsByInAccendingOrderByPrice()
                                                  throws RecordNotFoundException

Retrieve all products sorted in ascending order of price.

Specified by:

getAllProductsByInAccendingOrderByPrice in interface AdminDao

Returns:

A ResultSet containing information about all products sorted by price in ascending order.

Throws:

RecordNotFoundException - If no products are found.

getAllProductsByQuantity

public ResultSet getAllProductsByQuantity(int from,
 int to)
                                   throws RecordNotFoundException

Retrieve all products within a specified quantity range.

Specified by:

getAllProductsByQuantity in interface AdminDao

Parameters:

from - The minimum quantity.

to - The maximum quantity.

Returns:

A ResultSet containing information about all products within the specified quantity range.

Throws:

RecordNotFoundException - If no products are found within the specified quantity range.

getAllTransaction

public ResultSet getAllTransaction()
                            throws RecordNotFoundException

Retrieve all transactions.

Specified by:

getAllTransaction in interface AdminDao

Returns:

A ResultSet containing information about all transactions.

Throws:

RecordNotFoundException - If no transactions are found.

getAllTransactionbyDateRange

public ResultSet getAllTransactionbyDateRange(LocalDate startDate,
 LocalDate endDate)
                                       throws RecordNotFoundException

Retrieve all transactions within a specific date range.

Specified by:

getAllTransactionbyDateRange in interface AdminDao

Parameters:

startDate - The start date of the range.

endDate - The end date of the range.

Returns:

A ResultSet containing information about all transactions within the specified date range.

Throws:

RecordNotFoundException - If no transactions are found within the specified date range.

getTransactionById

public ResultSet getTransactionById(int id)
                             throws RecordNotFoundException

Retrieve a transaction by its ID.

Specified by:

getTransactionById in interface AdminDao

Parameters:

id - The ID of the transaction.

Returns:

A ResultSet containing information about the transaction with the specified ID.

Throws:

RecordNotFoundException - If no transaction is found with the specified ID.

getAllTransactionByPurchaseDate

public ResultSet getAllTransactionByPurchaseDate()
                                          throws RecordNotFoundException

Retrieve all transactions sorted by purchase date.

Specified by:

getAllTransactionByPurchaseDate in interface AdminDao

Returns:

A ResultSet containing information about all transactions sorted by purchase date.

Throws:

RecordNotFoundException - If no transactions are found.

getAllTransactionByQuantity

public ResultSet getAllTransactionByQuantity()
                                      throws RecordNotFoundException

Retrieve all transactions sorted by quantity.

Specified by:

getAllTransactionByQuantity in interface AdminDao

Returns:

A ResultSet containing information about all transactions sorted by quantity.

Throws:

RecordNotFoundException - If no transactions are found.

getAllTransactionByGSTPercentage

public ResultSet getAllTransactionByGSTPercentage()
                                           throws RecordNotFoundException

Retrieve all transactions sorted by GST percentage.

Specified by:

getAllTransactionByGSTPercentage in interface AdminDao

Returns:

A ResultSet containing information about all transactions sorted by GST percentage.

Throws:

RecordNotFoundException - If no transactions are found.

getAllTransactionByTotalPrice

public ResultSet getAllTransactionByTotalPrice()
                                        throws RecordNotFoundException

Retrieve all transactions sorted by total price.

Specified by:

getAllTransactionByTotalPrice in interface AdminDao

Returns:

A ResultSet containing information about all transactions sorted by total price.

Throws:

RecordNotFoundException - If no transactions are found.