public Boolean Update(OrderENT entOrder, SqlInt32 OrderID, SqlInt32 UserID) { OrderDAL dalOrder = new OrderDAL(); if (dalOrder.Update(entOrder, OrderID, UserID)) { return(true); } else { Message = dalOrder.Message; return(false); } }
public Boolean Insert(OrderENT entOrder) { OrderDAL dalOrder = new OrderDAL(); if (dalOrder.Insert(entOrder)) { return(true); } else { Message = dalOrder.Message; return(false); } }
public Boolean Insert(OrderENT entOrder) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_Order_Insert"; objCmd.Parameters.Add("@OrderID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; objCmd.Parameters.Add("@UserID", SqlDbType.Int).Value = entOrder.UserID; objCmd.Parameters.Add("@CartID", SqlDbType.Int).Value = entOrder.CartID; objCmd.Parameters.Add("@AddressID", SqlDbType.Int).Value = entOrder.AddressID; objCmd.Parameters.Add("@Total", SqlDbType.Int).Value = entOrder.Total; #endregion prepare Command objCmd.ExecuteNonQuery(); if (objCmd.Parameters["@OrderID"] != null) { entOrder.OrderID = Convert.ToInt32(objCmd.Parameters["@OrderID"].Value); } return(true); } catch (SqlException sqlex) { Message = sqlex.InnerException.Message; return(false); } catch (Exception ex) { Message = ex.InnerException.Message; return(false); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } } }
public Boolean Update(OrderENT entOrder, SqlInt32 OrderID, SqlInt32 UserID) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_Order_Update"; objCmd.Parameters.AddWithValue("@OrderID", OrderID); objCmd.Parameters.AddWithValue("@UserID", UserID); objCmd.Parameters.AddWithValue("@CartID", entOrder.CartID); objCmd.Parameters.AddWithValue("@AddressID", entOrder.AddressID); objCmd.Parameters.AddWithValue("@Total", entOrder.Total); #endregion prepare Command objCmd.ExecuteNonQuery(); return(true); } catch (SqlException sqlex) { Message = sqlex.InnerException.Message; return(false); } catch (Exception ex) { Message = ex.InnerException.Message; return(false); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } } }
protected void btnPlaceOrder_Click(object sender, EventArgs e) { OrderENT entOrder = new OrderENT(); OrderBAL balOrder = new OrderBAL(); for (int i = 0; i < rptCheckout.Items.Count; i++) { entOrder.UserID = Convert.ToInt32(Session["UserID"]); entOrder.CartID = Convert.ToInt32((rptCheckout.Items[i].FindControl("lblCartID") as Label).Text); entOrder.AddressID = Convert.ToInt32(Session["AddressID"]); entOrder.Total = Convert.ToInt32((rptCheckout.Items[i].FindControl("lbltempTotal") as Label).Text); if (balOrder.Insert(entOrder)) { ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "successalert();", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "faileralert();", true); } } }