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