public static void DeleteAccount(Object AccountDelete)
{
SqlCommand cmd = new SqlCommand("Delete_User");
cmd.Parameters.AddWithValue("@email", AccountDelete.Email);
DBLAYER.ExecuteProcedure(cmd);
}
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 void StatusUpdate(Object UpdateStatus)
{
SqlCommand cmd = new SqlCommand("Update_DeliveryStatus");
cmd.Parameters.AddWithValue("@orderid", UpdateStatus.Order_Id);
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 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 void UpdateOrder(Object OrderUpdate)
{
SqlCommand cmd = new SqlCommand("Update_OrderStatus");
cmd.Parameters.AddWithValue("@orderid", OrderUpdate.Order_Id);
cmd.Parameters.AddWithValue("@orderdate", OrderUpdate.Order_Date);
cmd.Parameters.AddWithValue("@ordertime", OrderUpdate.Order_Time);
DBLAYER.ExecuteProcedure(cmd);
}
//public static void SaveProduct(Object ProductSave)
//{
// SqlCommand cmd = new SqlCommand("Product_Detail");
// cmd.Parameters.AddWithValue("@categoryid", ProductSave.Category_Id);
// cmd.Parameters.AddWithValue("@productname", ProductSave.Product_Name);
// cmd.Parameters.AddWithValue("@date", ProductSave.Created_Date);
// DBLAYER.ExecuteProcedure(cmd);
//}
public static void SaveBrand(Object BrandSave)
{
SqlCommand cmd = new SqlCommand("Brand_Details");
cmd.Parameters.AddWithValue("@productid", BrandSave.Product_Id);
cmd.Parameters.AddWithValue("@brandname", BrandSave.Product_Brand);
cmd.Parameters.AddWithValue("@date", BrandSave.Created_Date);
DBLAYER.ExecuteProcedure(cmd);
}
public static void UpdateProfile(Object ProfileUpdate)
{
SqlCommand cmd = new SqlCommand("Update_Profile");
cmd.Parameters.AddWithValue("@email", ProfileUpdate.Email);
cmd.Parameters.AddWithValue("@mobile", ProfileUpdate.Mobile);
cmd.Parameters.AddWithValue("@address", ProfileUpdate.Address);
cmd.Parameters.AddWithValue("@name", ProfileUpdate.Name);
cmd.Parameters.AddWithValue("@pin", ProfileUpdate.Pincode);
DBLAYER.ExecuteProcedure(cmd);
}
public static void usercontact(Object contactuser)
{
SqlCommand cmd = new SqlCommand("Contact_User");
cmd.Parameters.AddWithValue("@mail", contactuser.Email);
cmd.Parameters.AddWithValue("@name", contactuser.Name);
cmd.Parameters.AddWithValue("@phone", contactuser.Mobile);
cmd.Parameters.AddWithValue("@query", contactuser.Query);
cmd.Parameters.AddWithValue("@date", contactuser.Created_Date);
DBLAYER.ExecuteProcedure(cmd);
}
public static void saveoffer(Object offersave)
{
SqlCommand cmd = new SqlCommand("Save_Product");
cmd.Parameters.AddWithValue("@categoryid", offersave.Product_Id);
cmd.Parameters.AddWithValue("@productname", offersave.Product_Name);
cmd.Parameters.AddWithValue("@brandname", offersave.Product_Brand);
cmd.Parameters.AddWithValue("@offer", offersave.Product_Offer);
cmd.Parameters.AddWithValue("@date", offersave.Created_Date);
DBLAYER.ExecuteProcedure(cmd);
}
public static void ReturnPolicy(Object PolicyReturn)
{
SqlCommand cmd = new SqlCommand("Insert_Return");
cmd.Parameters.AddWithValue("@email", PolicyReturn.Email);
cmd.Parameters.AddWithValue("@orderid", PolicyReturn.Order_Id);
cmd.Parameters.AddWithValue("@returntype", PolicyReturn.Return_Type);
cmd.Parameters.AddWithValue("@message", PolicyReturn.Message);
cmd.Parameters.AddWithValue("@date", PolicyReturn.Created_Date);
cmd.Parameters.AddWithValue("@month", PolicyReturn.Month);
DBLAYER.ExecuteProcedure(cmd);
}
public static void signupuser(Object usersignup)
{
SqlCommand cmd = new SqlCommand("Register_User");
cmd.Parameters.AddWithValue("@email", usersignup.Email);
cmd.Parameters.AddWithValue("@name", usersignup.Name);
cmd.Parameters.AddWithValue("@phone", usersignup.Mobile);
cmd.Parameters.AddWithValue("@address", usersignup.Address);
cmd.Parameters.AddWithValue("@password", usersignup.Password);
cmd.Parameters.AddWithValue("@pincode", usersignup.Pincode);
DBLAYER.ExecuteProcedure(cmd);
}
public static void inserttransaction(Object transactioninsert)
{
SqlCommand cmd = new SqlCommand("Insert_Transaction");
cmd.Parameters.AddWithValue("@transactionid", transactioninsert.Transaction_Id);
cmd.Parameters.AddWithValue("@orderid", transactioninsert.Order_Id);
cmd.Parameters.AddWithValue("@email", transactioninsert.Email);
cmd.Parameters.AddWithValue("@mobile", transactioninsert.Mobile);
cmd.Parameters.AddWithValue("@transactionamount", transactioninsert.Transaction_Amount);
cmd.Parameters.AddWithValue("@transactiondate", transactioninsert.Transaction_Date);
cmd.Parameters.AddWithValue("@transactiontime", transactioninsert.Transaction_Time);
DBLAYER.ExecuteProcedure(cmd);
}
//public static void saveprice(Object pricesave)
//{
// SqlCommand cmd = new SqlCommand("Save_Price");
// cmd.Parameters.AddWithValue("@categoryid", pricesave.Category_Id);
// cmd.Parameters.AddWithValue("@productid", pricesave.Product_Id);
// cmd.Parameters.AddWithValue("@productquantity", pricesave.Product_Quantity);
// cmd.Parameters.AddWithValue("@productprice", pricesave.Product_Price);
// cmd.Parameters.AddWithValue("@date", pricesave.Created_Date);
// DBLAYER.ExecuteProcedure(cmd);
//}
public static void saveprice(Object pricesave)
{
SqlCommand cmd = new SqlCommand("Save_Price");
cmd.Parameters.AddWithValue("@categoryid", pricesave.Category_Id);
cmd.Parameters.AddWithValue("@productid", pricesave.Product_Id);
cmd.Parameters.AddWithValue("@brandid", pricesave.Brand_Id);
cmd.Parameters.AddWithValue("@productquantity", pricesave.Product_Quantity);
cmd.Parameters.AddWithValue("@productprice", pricesave.Product_Price);
cmd.Parameters.AddWithValue("@date", pricesave.Created_Date);
DBLAYER.ExecuteProcedure(cmd);
}
public static void UpdateProduct(Object ProductUpdate)
{
SqlCommand cmd = new SqlCommand("Update_Product");
cmd.Parameters.AddWithValue("@productid", ProductUpdate.Product_Id);
cmd.Parameters.AddWithValue("@productquantity", ProductUpdate.Product_Quantity);
cmd.Parameters.AddWithValue("@productmrp", ProductUpdate.Product_MRP);
cmd.Parameters.AddWithValue("@productprice", ProductUpdate.Product_Price);
cmd.Parameters.AddWithValue("@productoffer", ProductUpdate.Product_Offer);
cmd.Parameters.AddWithValue("@productdesc", ProductUpdate.Product_Description);
cmd.Parameters.AddWithValue("@instock", ProductUpdate.InStock);
DBLAYER.ExecuteProcedure(cmd);
}
public static void InsertSaleDetails(Object SaleDetailsInsert)
{
SqlCommand cmd = new SqlCommand("Save_SaleDetails");
cmd.Parameters.AddWithValue("@orderid", SaleDetailsInsert.Order_Id);
cmd.Parameters.AddWithValue("@date", SaleDetailsInsert.Transaction_Date);
cmd.Parameters.AddWithValue("@year", SaleDetailsInsert.Year);
cmd.Parameters.AddWithValue("@month", SaleDetailsInsert.Month);
cmd.Parameters.AddWithValue("@saleprice", SaleDetailsInsert.Sale_Price);
cmd.Parameters.AddWithValue("@costprice", SaleDetailsInsert.Cost_Price);
cmd.Parameters.AddWithValue("@profit", SaleDetailsInsert.Profit_Loss);
DBLAYER.ExecuteProcedure(cmd);
}
public static void insertorder(Object orderinsert)
{
SqlCommand cmd = new SqlCommand("Insert_Order");
cmd.Parameters.AddWithValue("@orderid", orderinsert.Order_Id);
cmd.Parameters.AddWithValue("@amount", orderinsert.Amount);
cmd.Parameters.AddWithValue("@name", orderinsert.Name);
cmd.Parameters.AddWithValue("@email", orderinsert.Email);
cmd.Parameters.AddWithValue("@mobile", orderinsert.Mobile);
cmd.Parameters.AddWithValue("@address", orderinsert.Address);
cmd.Parameters.AddWithValue("@pin", orderinsert.Pincode);
cmd.Parameters.AddWithValue("@order_date", orderinsert.Order_Date);
cmd.Parameters.AddWithValue("@order_time", orderinsert.Order_Time);
cmd.Parameters.AddWithValue("@deliverycharges", orderinsert.Delivery_Charges);
DBLAYER.ExecuteProcedure(cmd);
}
public static void saveproduct(Object productsave)
{
SqlCommand cmd = new SqlCommand("Save_Product");
cmd.Parameters.AddWithValue("@categoryid", productsave.Category_Id);
cmd.Parameters.AddWithValue("@productname", productsave.Product_Name);
cmd.Parameters.AddWithValue("@brandname", productsave.Product_Brand);
cmd.Parameters.AddWithValue("@productquantity", productsave.Product_Quantity);
cmd.Parameters.AddWithValue("@productmrp", productsave.Product_MRP);
//cmd.Parameters.AddWithValue("@productmargin", productsave.Product_Margin);
cmd.Parameters.AddWithValue("@productprice", productsave.Product_Price);
cmd.Parameters.AddWithValue("@productimage", productsave.Product_Image);
cmd.Parameters.AddWithValue("@productdescription", productsave.Product_Description);
cmd.Parameters.AddWithValue("@productoffer", productsave.Product_Offer);
cmd.Parameters.AddWithValue("@instock", productsave.InStock);
cmd.Parameters.AddWithValue("@date", productsave.Created_Date);
DBLAYER.ExecuteProcedure(cmd);
}
public static void InsertOrderItem(Object OrderItemInsert)
{
SqlCommand cmd = new SqlCommand("Insert_OrderItems");
cmd.Parameters.AddWithValue("@orderid", OrderItemInsert.Order_Id);
// cmd.Parameters.AddWithValue("@email", OrderItemInsert.Email);
//cmd.Parameters.AddWithValue("@mobile", OrderItemInsert.Mobile);
cmd.Parameters.AddWithValue("@productid", OrderItemInsert.Product_Id);
//cmd.Parameters.AddWithValue("@productname", OrderItemInsert.Product_Name);
//cmd.Parameters.AddWithValue("@productbrand", OrderItemInsert.Product_Brand);
//cmd.Parameters.AddWithValue("@productqunatity", OrderItemInsert.Product_Quantity);
//cmd.Parameters.AddWithValue("@productprice", OrderItemInsert.Product_Price);
cmd.Parameters.AddWithValue("@productunit", OrderItemInsert.Product_Unit);
cmd.Parameters.AddWithValue("@totalprice", OrderItemInsert.Total_Price);
//cmd.Parameters.AddWithValue("@productdescription", OrderItemInsert.Product_Description);
// cmd.Parameters.AddWithValue("@productoffer", OrderItemInsert.Product_Offer);
cmd.Parameters.AddWithValue("@year", OrderItemInsert.Year);
cmd.Parameters.AddWithValue("@month", OrderItemInsert.Month);
cmd.Parameters.AddWithValue("@date", OrderItemInsert.Created_Date);
DBLAYER.ExecuteProcedure(cmd);
}