public static void StatusUpdate(Object UpdateStatus)
{
SqlCommand cmd = new SqlCommand("Update_DeliveryStatus");
cmd.Parameters.AddWithValue("@orderid", UpdateStatus.Order_Id);
DBLAYER.ExecuteProcedure(cmd);
}
public static DataTable SelectOrderId(Object OrderIdSelect)
{
SqlCommand cmd = new SqlCommand("Select_OrderId");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable PendingOrder(Object OrderPending)
{
SqlCommand cmd = new SqlCommand("Fill_PendingOrders");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable categoryfill(Object fillcategory)
{
SqlCommand cmd = new SqlCommand("Fill_Category");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable ViewSale(Object SaleView)
{
SqlCommand cmd = new SqlCommand("Select_Sales");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable ViewUser(Object UserView)
{
SqlCommand cmd = new SqlCommand("View_User");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable pricefill(Object fillprice)
{
SqlCommand cmd = new SqlCommand("Select_Products");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static void DeleteAccount(Object AccountDelete)
{
SqlCommand cmd = new SqlCommand("Delete_User");
cmd.Parameters.AddWithValue("@email", AccountDelete.Email);
DBLAYER.ExecuteProcedure(cmd);
}
public static void DeleteTransactionOrder(Object TransactionOrderDelete)
{
SqlCommand cmd = new SqlCommand("Delete_Order_Transaction");
cmd.Parameters.AddWithValue("@orderid", TransactionOrderDelete.Order_Id);
DBLAYER.ExecuteProcedure(cmd);
}
public static DataTable CompleteTransaction(Object TransactionComplete)
{
SqlCommand cmd = new SqlCommand("Select_DeliveredTransaction");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable UserInfo(Object InfoUser)
{
SqlCommand cmd = new SqlCommand("Select_Users");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable BrandName(Object NameBrand)
{
SqlCommand cmd = new SqlCommand("View_Brand");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable AllOrders(Object OrdersAll)
{
SqlCommand cmd = new SqlCommand("Select_AllOrders");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable UserFeedback(Object FeedbackUser)
{
SqlCommand cmd = new SqlCommand("Show_Review");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static void DeleteOrderList(Object OrderListDelete)
{
SqlCommand cmd = new SqlCommand("Delete_Order_OrderList");
cmd.Parameters.AddWithValue("@orderid", OrderListDelete.Order_Id);
DBLAYER.ExecuteProcedure(cmd);
}
public static DataTable SelectQuantity(Object QuantitySelect)
{
SqlCommand cmd = new SqlCommand("FillQuantityByProduct");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable quantityfill(Object fillquantity)
{
SqlCommand cmd = new SqlCommand("Fill_Quantity");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable FillOffer(Object OfferFill)
{
SqlCommand cmd = new SqlCommand("Fill_Offer");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable ProductInfo(Object InfoProduct)
{
SqlCommand cmd = new SqlCommand("Select_AllProducts");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable AllTransaction(Object TransactionAll)
{
SqlCommand cmd = new SqlCommand("Select_PendingTransactions");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable MonsoonFoodProduct(Object ProductMonsoonFood)
{
SqlCommand cmd = new SqlCommand("FillMonsoonFoods");
//cmd.Parameters.AddWithValue("@productname", ProductIndividual.Product_Name);
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static void UpdateEmail(Object EmailUpdate)
{
SqlCommand cmd = new SqlCommand("Update_Email");
cmd.Parameters.AddWithValue("@email", EmailUpdate.Email);
cmd.Parameters.AddWithValue("@mobile", EmailUpdate.Mobile);
DBLAYER.ExecuteProcedure(cmd);
}
public static void UpdatePassword(Object PasswordUpdate)
{
SqlCommand cmd = new SqlCommand("Update_Password");
cmd.Parameters.AddWithValue("@mobile", PasswordUpdate.Mobile);
cmd.Parameters.AddWithValue("@password", PasswordUpdate.Password);
DBLAYER.ExecuteProcedure(cmd);
}
public static DataTable BabyProducts(Object ProductsBaby)
{
SqlCommand cmd = new SqlCommand("BabyFood");
//cmd.Parameters.AddWithValue("@productname", ProductIndividual.Product_Name);
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable FetchPassword(Object PasswordFetch)
{
SqlCommand cmd = new SqlCommand("Fetch_Password");
cmd.Parameters.AddWithValue("@email", PasswordFetch.Email);
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable ProductByCatagory(Object CatagoryByProduct)
{
SqlCommand cmd = new SqlCommand("ViewProductByCatagory");
cmd.Parameters.AddWithValue("@catagoryname", CatagoryByProduct.Category_Name);
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable FetchProduct(Object ProductFetch)
{
SqlCommand cmd = new SqlCommand("Edit_Product");
cmd.Parameters.AddWithValue("@productid", ProductFetch.Product_Id);
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable selectbrand(Object brandselect)
{
SqlCommand cmd = new SqlCommand("Fill_Brand");
cmd.Parameters.AddWithValue("@productid", brandselect.Product_Id);
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable ProductName(Object NameProduct)
{
SqlCommand cmd = new SqlCommand("View_Productbybrand");
cmd.Parameters.AddWithValue("@brand", NameProduct.Product_Brand);
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable selecttransaction(Object transactionselect)
{
SqlCommand cmd = new SqlCommand("Select_Transactiondetails");
cmd.Parameters.AddWithValue("@email", transactionselect.Email);
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
