Exemple #1
0
        internal DataSet GetOrderDetails(RecentOrderBO recentOrderBO)
        {
            DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(recentOrderBO.ConString);
            SqlCommand          command   = sqlHelper.CreateCommand(CommandType.StoredProcedure);

            command.CommandText = "GetOrdersDetailsToConfirmAndroid";
            sqlHelper.AddParameter(command, "@OrderId", recentOrderBO.OrderId, ParameterDirection.Input);
            return(sqlHelper.ExecuteDataSet(command));
        }
Exemple #2
0
        internal int updateOrderStatus(RecentOrderBO recentOrderBO)
        {
            DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(recentOrderBO.ConString);
            SqlCommand          command   = sqlHelper.CreateCommand(CommandType.StoredProcedure);

            command.CommandText = "UpdateOrderStatus";
            sqlHelper.AddParameter(command, "@OrderId", recentOrderBO.UpdateOrderId, ParameterDirection.Input);
            sqlHelper.AddParameter(command, "@OrderStatus", recentOrderBO.Status, ParameterDirection.Input);
            return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command)));
        }