/*public bool DeleteCartBL(Cart cart)
* {
* bool cartDeleted = false;
* try
* {
* if (ValidateCart(cart))
* {
* OrderIngredientDAL orderIngredientDAL = new OrderIngredientDAL();
* cartDeleted = orderIngredientDAL.DeleteCartDAL(cart);
* }
* }
* catch (RecipeIngredientSystemExceptions)
* {
* throw;
* }
* catch (Exception ex)
* {
* throw ex;
* }
* return cartDeleted;
* }*/
//add order details
public bool AddOrderBL(OrderCartIngredient orderadd, string username)
{
try
{
if (orderadd != null)
{
//validate order details before adding
if (ValidateOrderDetails(orderadd))
{
OrderIngredientDAL orderIngredientDAL = new OrderIngredientDAL();
if (orderIngredientDAL.AddOrderDAL(orderadd, username))
{
return(true);
}
else
{
throw new RecipeIngredientSystemExceptions("Empty Fields");
}
}
}
}
catch (RecipeIngredientSystemExceptions)
{
throw;
}
catch (NullReferenceException)
{
MessageBox.Show("Details Incomplete");
}
catch (Exception ex)
{
throw ex;
}
return(false);
}
private void Orderbtn_Click(object sender, RoutedEventArgs e)
{
OrderCartIngredient orderAdded = new OrderCartIngredient();
OrderIngredientBL orderIngredientBL = new OrderIngredientBL();
try
{
string username = "";
//check null values
if (!string.IsNullOrEmpty(txtusername.Text))
{
username = txtusername.Text;//username textbox
}
orderAdded = CheckNullsforOrderAdd();
bool result = orderIngredientBL.AddOrderBL(orderAdded, username);
if (result == true)
{
MessageBox.Show("Order Placed!");
this.Close();
ShippingDetails shipppingpage = new ShippingDetails(txtusername.Text);
//redirect to shipping details page
shipppingpage.Show();
}
else
{
MessageBox.Show("Order not Placed!");
}
}
catch (RecipeIngredientSystemExceptions ex)
{
MessageBox.Show(ex.Message);
}
}
//add order
public bool AddOrderDAL(OrderCartIngredient orderadd, string username)
{
bool orderAdded = false;
//Connection to database
SqlConnection objCon = new SqlConnection(Database.ConnectionString);
//get sql stored procedure to execute
SqlCommand objCom = new SqlCommand(Database.PLACEORDER, objCon);
//setting command type to stored procedure
objCom.CommandType = CommandType.StoredProcedure;
//declare the variables
string mobilenum;
string address;
decimal tamount;
decimal gtotal;
//assign values to the variables
mobilenum = orderadd.MobileNumber;
address = orderadd.DeliveryAddress;
tamount = orderadd.TotalBillAmount;
gtotal = orderadd.GrandTotal;
//define sql parameters
SqlParameter objSP_username = new SqlParameter("@username", username);
SqlParameter objSP_mobilenum = new SqlParameter("@MobileNumber", mobilenum);
SqlParameter objSP_address = new SqlParameter("@DeliveryAddress", address);
SqlParameter objSP_tamount = new SqlParameter("@TotalBillAmount", tamount);
SqlParameter objSP_gtotal = new SqlParameter("@GrandTotal", gtotal);
//add parameters
objCom.Parameters.Add(objSP_username);
objCom.Parameters.Add(objSP_mobilenum);
objCom.Parameters.Add(objSP_address);
objCom.Parameters.Add(objSP_tamount);
objCom.Parameters.Add(objSP_gtotal);
//open connection
objCon.Open();
int i = objCom.ExecuteNonQuery();
//close connection
objCon.Close();
try
{
if (i > 0)
{
orderAdded = true;
}
}
catch (Exception ex)
{
string
errormessage = ex.Message;
throw new RecipeIngredientSystemExceptions(errormessage);
}
return(orderAdded);
}
//validate orderdetails
public static bool ValidateOrderDetails(OrderCartIngredient order)
{
StringBuilder sb = new StringBuilder();
bool validOrder = true;
if (String.IsNullOrEmpty(order.MobileNumber) || order.MobileNumber.Length != 10)
{
validOrder = false;
sb.Append(Environment.NewLine + "Required 10 Digit Mobile Number");
//return false;
}
else
{
if (order.MobileNumber.Length < 10)
{
validOrder = false;
sb.Append(Environment.NewLine + "Required 10 Digit Mobile Number");
}
}
if (order.DeliveryAddress == string.Empty || order.DeliveryAddress == null)
{
validOrder = false;
sb.Append(Environment.NewLine + "Delivery Address Required");
}
if (order.TotalBillAmount <= 0)
{
validOrder = false;
sb.Append(Environment.NewLine + "Invalid Bill Amount");
}
if (order.GrandTotal <= 0)
{
validOrder = false;
sb.Append(Environment.NewLine + "Invalid Grand Total");
}
if (validOrder == false)
{
throw new RecipeIngredientSystemExceptions(sb.ToString());
}
return(validOrder);
}
//check null values for add order
private OrderCartIngredient CheckNullsforOrderAdd()
{
OrderCartIngredient orderAdded = new OrderCartIngredient();
if (!string.IsNullOrEmpty(txtmobilenum.Text))
{
orderAdded.MobileNumber = txtmobilenum.Text;//mobile number textbox
}
if (!string.IsNullOrEmpty(txtaddress.Text))
{
orderAdded.DeliveryAddress = txtaddress.Text;//delivery address textbox
}
if (!string.IsNullOrEmpty(txttamount.Text))
{
orderAdded.TotalBillAmount = Convert.ToDecimal(txttamount.Text);//total bill amount textbox
}
if (!string.IsNullOrEmpty(txtgtotal.Text))
{
orderAdded.GrandTotal = Convert.ToDecimal(txtgtotal.Text);//grand amount textbox
}
return(orderAdded);
}
