internal void CancelOrders(CancelledOrdersBO cancelledOrdersBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(cancelledOrdersBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspCancelledOrderDetails"; sqlHelper.AddParameter(command, "@Mode", "3", ParameterDirection.Input); sqlHelper.AddParameter(command, "@OrderId", cancelledOrdersBO.orderIds, ParameterDirection.Input); sqlHelper.ExecuteNonQuery(command); }
internal DataSet getProductList(CancelledOrdersBO cancelledOrdersBO, int orderId) { DataSet dt = new DataSet(); DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(cancelledOrdersBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspCancelledOrderDetails"; sqlHelper.AddParameter(command, "@Mode", "2", ParameterDirection.Input); sqlHelper.AddParameter(command, "@OrderId", orderId, ParameterDirection.Input); dt = sqlHelper.ExecuteDataSet(command); return(dt); }
public DataSet GetCancelledOrdersDetails(CancelledOrdersBO cancelledOrdersBO) { DataSet dt = new DataSet(); DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(cancelledOrdersBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspCancelledOrderDetails"; sqlHelper.AddParameter(command, "@Mode", cancelledOrdersBO.Mode, ParameterDirection.Input); sqlHelper.AddParameter(command, "@OrderTakenBy", cancelledOrdersBO.OrderTakenBy, ParameterDirection.Input); sqlHelper.AddParameter(command, "@ShopId", cancelledOrdersBO.ShopId, ParameterDirection.Input); dt = sqlHelper.ExecuteDataSet(command); return(dt); }