public void CancelOrder(ViewOrdersPageObject obj)
{
global.OpenConnection(obj.ViewOrdersPageConnectionString);
global.startTransaction();
try
{
Sql = "UPDATE \"Group2DB\".\"ProductManagement\" SET \"ProductStatusID\"='5' WHERE (\"ProductManagementID\"=" + obj.ViewOrdersPageProductManagementID + ")";
global.Datasource(Sql);
DataTable Dt;
int stock;
Sql = "SELECT \"Group2DB\".\"Product\".\"Stock\" FROM \"Group2DB\".\"Product\"" +
"WHERE \"Group2DB\".\"Product\".\"ProductID\" = " + obj.ViewOrdersPageProductID + "";
Dt = global.Datasource(Sql);
stock = int.Parse(Dt.Rows[0]["Stock"].ToString());
stock += obj.ViewOrdersPagerNumberOfPurchased;
Sql = "UPDATE \"Group2DB\".\"Product\" SET \"Stock\"=" + stock + " WHERE (\"ProductID\"=" + obj.ViewOrdersPageProductID + ")";
global.Datasource(Sql);
global.commitQuery();
global.closeTransaction();
}
catch (Exception e)
{
global.rollBackQuery();
}
}
public DataTable LoadAlProductStatus(ViewOrdersPageObject obj)
{
global.OpenConnection(obj.ViewOrdersPageConnectionString);
global.startTransaction();
Sql = "SELECT" +
" \"Group2DB\".\"ProductStatus\".\"Description\"," +
" \"Group2DB\".\"ProductStatus\".\"ProductStatusID\"" +
"FROM" +
"\"Group2DB\".\"ProductStatus\"";
return(global.Datasource(Sql));
}
public DataTable LoadAllMyOrders(ViewOrdersPageObject obj)
{
global.OpenConnection(obj.ViewOrdersPageConnectionString);
global.startTransaction();
Sql = "SELECT" +
"\"Group2DB\".\"ProductManagement\".\"ProductManagementID\"," +
"\"Group2DB\".\"ProductManagement\".\"ProductID\" AS \"_ProductID\"," +
"\"Group2DB\".\"Product\".\"ProductName\"," +
"\"Subquery\".\"Price\"," +
"\"Group2DB\".\"ProductManagement\".\"NumberOfPurchased\"," +
"\"Subquery\".\"Total Price\"," +
"\"Group2DB\".\"ProductShippment\".\"ShippingAddress\"," +
"\"Group2DB\".\"ProductShippment\".\"ShippingDate\"," +
"\"Group2DB\".\"ProductShippment\".\"DeliveryDate\"," +
"\"Group2DB\".\"ProductTimePurchased\".\"TimePurchased\"," +
"\"Group2DB\".\"ProductStatus\".\"Description\"," +
"\"Group2DB\".\"ProductManagement\".\"ProductStatusID\" AS \"_ProductStatusID\"" +
"FROM" +
"\"Group2DB\".\"ProductManagement\"" +
"INNER JOIN \"Group2DB\".\"Product\" ON \"Group2DB\".\"ProductManagement\".\"ProductID\" = \"Group2DB\".\"Product\".\"ProductID\"" +
"INNER JOIN \"Group2DB\".\"ProductPrice\" ON \"Group2DB\".\"ProductPrice\".\"ProductID\" = \"Group2DB\".\"Product\".\"ProductID\"" +
"INNER JOIN(" +
" SELECT" +
"\"Group2DB\".\"ProductManagement\".\"ProductManagementID\"," +
"\"Group2DB\".\"ProductPrice\".\"Price\"," +
"SUM(" +
"\"Group2DB\".\"ProductManagement\".\"NumberOfPurchased\" * \"Group2DB\".\"ProductPrice\".\"Price\"" +
") AS \"Total Price\"" +
"FROM" +
"\"Group2DB\".\"ProductManagement\"" +
" INNER JOIN \"Group2DB\".\"ProductPrice\" ON \"Group2DB\".\"ProductPrice\".\"ProductID\" = \"Group2DB\".\"ProductManagement\".\"ProductID\"" +
" GROUP BY" +
"\"Group2DB\".\"ProductManagement\".\"ProductManagementID\"," +
" \"Group2DB\".\"ProductPrice\".\"Price\"" +
") AS \"Subquery\" ON \"Group2DB\".\"ProductManagement\".\"ProductManagementID\" = \"Subquery\".\"ProductManagementID\"" +
"INNER JOIN \"Group2DB\".\"ProductShippment\" ON \"Group2DB\".\"ProductShippment\".\"ProductManagementID\" = \"Group2DB\".\"ProductManagement\".\"ProductManagementID\"" +
"INNER JOIN \"Group2DB\".\"ProductTimePurchased\" on \"Group2DB\".\"ProductManagement\".\"ProductManagementID\" = \"Group2DB\".\"ProductTimePurchased\".\"ProductManagementID\" " +
"INNER JOIN \"Group2DB\".\"ProductStatus\" ON \"Group2DB\".\"ProductManagement\".\"ProductStatusID\" = \"Group2DB\".\"ProductStatus\".\"ProductStatusID\"" +
"Where \"Group2DB\".\"ProductManagement\".\"CustomerID\" = " + obj.ViewOrdersPageCustomerID + "";
if (obj.ViewOrdersPageSearchButtonIsClicked == true && obj.ViewOrdersPageSelectedStatus != 1)
{
Sql += " AND \"Group2DB\".\"ProductManagement\".\"ProductStatusID\" = " + obj.ViewOrdersPageSelectedStatus + "";
}
Sql += " ORDER BY" +
"\"Group2DB\".\"ProductManagement\".\"ProductManagementID\" ASC";
return(global.Datasource(Sql));
}
