/*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); }